Supplier external invoice upload in xml format

Hello,

Does anyone know the XML fields required in order to populate an alternate payment method and payment address?   For txt file types this works fine using the N type fields Payment Method and Payment Address. We need the equivalent fields in the XML file layout

Thank you!

example of some of the xml rows

Hi @Rcoubrou 

how is your process?

Do you export the xml file from your DMS system and import to IFS?

OK, then you should check the settings of the supplier.

In the xml file these tags are not available.

@bytsophan we did not get a solution for this therefore built our own work around.  Using the “paymentTermsFreeText” field we are populating our alternate remit address and payment method to be entered in position one and two. Then we’ve built a custom event to update this in the installment plan once it’s in the posting proposal form. It’s working well.   We are a CAD company that deals with non deductible tax codes which is also not handled in the XML file so added that in this field as well using position 3 and 4 (therefore in sample below the amounts you see are taxes separate by semicolon).   Not ideal to have these “hacks” but on this version for now anyhow, we are stuck.  At least it automates it for us.

Hi,

with the xml an account information can be transferred. BUT the account is “only” validated against the default account setup on the supplier.

If I recall correctly it would not be able to pass another payment information even if it is available in supplier payment method basic data and is not default.

Kind regards

Ralph

@bytsophan we did not get a solution for this therefore built our own work around.  Using the “paymentTermsFreeText” field we are populating our alternate remit address and payment method to be entered in position one and two. Then we’ve built a custom event to update this in the installment plan once it’s in the posting proposal form. It’s working well.   We are a CAD company that deals with non deductible tax codes which is also not handled in the XML file so added that in this field as well using position 3 and 4 (therefore in sample below the amounts you see are taxes separate by semicolon).   Not ideal to have these “hacks” but on this version for now anyhow, we are stuck.  At least it automates it for us.

 

 

Hi Rcoubrou

 

Perfect thanks for the detailed workarround solution. I think this will also work for us.

by the way are you allowed to export the custom event?

 

Best Regards

sophal

Hi,

I am a technical developer that works with Rcoubrou, to ensure the privacy of our code I’ll avoid exporting it, but here is the full solution we are using:

1. Update the IFS_FINVOICE_TO_IFS_EINVOICE transformer. The paymentTermsFreeText value in the XML set to update c100 value (this will map to the invoice_tab.correction_reason field once the invoice is created 

   

    

2. Create custom event against the invoice_tab. It will fire whenever new objects are created. Ensure the correction field is one of the available attributes 

   

3. Create the event action that reads the value in the invoice_tab.correction_reason field
   • First created a function that reads the correction_reason value and returns the desired value. 

     

     

   • ​​​​​​​​​​​​​​Have the event use those values to do post processing at the time the invoice is created. It will need to be a background job to avoid mutating table errors. Here we have created a procedure that will run in a background job to set the payment method:

   • 

Best wishes,

-Lavon