Skip to main content
Solved

External invoice upload - Customer & Supplier


Forum|alt.badge.img+13

Hi,

I’m using external file templates STDCIN2 & STDSIN2 for customer invoice migration in upgrade project (2004 to App10). There is no field to update invoice series in the file & it is available only invoice type. System will pick the invoice series based on invoice type. 

This customer has multiple series for invoice type and any suggestions to handle this situation 

Invoice Type Invoice series
CUSTINV EP
CUSTINV GSP
CUSTINV GTI
CUSTINV HDM
CUSTINV LMS

Best answer by AkilaR

Hi @Narmada ,

Not sure if you have already tried this. But Isn’t it possible to use Combinations Per Invoice Type functionality for this purpose?

 

Regards,

Akila

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Ieva Rituma
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • 424 replies
  • August 4, 2021

Hi,

Assuming this is a re-implementation, when you are using the external file imports, this will create “Manual Customer Invoices” rather than Customer Invoices. Typically the invoice type for this is EXTINV rather than CUSTINV. Because when we are importing open items, they were created in the previous database and we also don’t load them with the correct tax (typically, to avoid creating tax transactions also in the new system) and creaint manual customer invoices implies that the invoices were generated in another system and the print option is not available in IFS. 

 

I would suggest you use the EXTINV for loading open items. 


Forum|alt.badge.img+13
  • Author
  • Hero (Employee)
  • 150 replies
  • August 4, 2021

hi @ IRituma,

Many thanks for he prompt response.

Agreed with your suggestion. However this customer wants to maintain same series ID as it is connected to reports logic buildup by their internal IT team. 

Best regards

Narmada

 


AkilaR
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 153 replies
  • Answer
  • August 4, 2021

Hi @Narmada ,

Not sure if you have already tried this. But Isn’t it possible to use Combinations Per Invoice Type functionality for this purpose?

 

Regards,

Akila


Forum|alt.badge.img+13
  • Author
  • Hero (Employee)
  • 150 replies
  • August 4, 2021

Hi @AkilaR  

Many thanks & its works.

Best Regards

Narmada


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings