EDI Invoice Handling Code Translation

unknown

We just went live with EDI 810 invoices this week, and are running into an issue with the default handling code for these invoices.  We set the handling code to default on the AP10 screen to MAT, but occasionally we get a SRVC invoice on the same EDI file as the MAT invoices.  It's a real pain point to have to go in and delete the SRVC invoice and then manually rebuild it.  Is there anyone else who went through this, and if so, what did you do to get the handling codes to default?

jon-athey

I've not seen this before, but if you can get the vendor to send a specific value on the 810 in BIG07 for service invoices vs. supply invoices, you can use these substitution table (ED40) records to default the SRVC or MAT handling code.



List Name: tpid_I_INVOICE_HC

Lawson Value: SRVC

External Value: SR (for example; not standard but you need to differentiate from supply type invoices)



List Name: tpid_I_INVOICE_HC

Lawson Value: MAT

External Value: PR ("product"; standard for supply type invoices)



The BIG segment will look something like this



BIG^20161114^952300888^20161114^713424^^^PR for supplies

or

BIG^20161114^952300888^20161114^713424^^^SR for services