Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Lewis Rosenberg]

Hello Everyone,

I can’t believe that I never had this issue before, but I am trying to map an EDI 810 that has SAC segments for invoice allowances (discounts).  The TDS 01 must contain the actual invoice amount (Amount_Including_VAT) – no problem with this.

The TDS 02 must contain the invoice amount not including the allowances.  I don’t see any invoice header fields that contain this value.  I found an EDI OUT field called “Inv. Amt. Before Inv. Disc.”, but when I map that I get a value of zero, so I am guessing there is something else I have to do to get that to work.  Does anyone know?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Advisory Board Member (Former Chairperson)
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————

[David Chiu]

Hi Lewis,
Were you able to resolve your issue?    If not, does your Data type = Dec Implied?   Not having the correct Data type seems to get me all the time.
We were able to export values when we had discounts loaded in the LAX EDI Discount tables as well as the Invoice Discount Amount Excl. Tax.  

——————————
David Chiu
Acoustic Ceiling Products
WI
——————————
——————————————-

[Lewis Rosenberg]

No, this is still unresolved.  I can get a value for the TDS 02, (and it is set to Decimal Implied).  I am just getting the wrong value.  The trade partner wants the total value of all of the order “Item” type lines.  We have G/L lines for allowances that are mapped to the SAC.  These should be included in the value mapped to the TDS 01 but not included in the value mapped to the TDS 02.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Advisory Board Member (Former Chairperson)
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————
——————————————-

[Lewis Rosenberg]

Issue resolved thanks to my friends at ArcherPoint.

The TDS 02 gets mapped to EDI OUT code GROSS INVOICE,
(The TDS 01 gets mapped to Sales Header field Amount_Including_VAT).

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Advisory Board Member (Former Chairperson)
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————
——————————————-