Solved

External invoice upload - Customer & Supplier

  • 4 August 2021
  • 4 replies
  • 364 views

Userlevel 7
Badge +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
icon

Best answer by AkilaR 4 August 2021, 14:46

View original

This topic has been closed for comments

4 replies

Userlevel 6
Badge +16

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. 

Userlevel 7
Badge +13

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

 

Userlevel 6
Badge +11

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

Userlevel 7
Badge +13

Hi @AkilaR  

Many thanks & its works.

Best Regards

Narmada