AR Invoice Distribution

 5 Replies
 2 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Jeff
Advanced Member
Posts: 30
Advanced Member

Hello all.  Rather new to Lawson so hopefully I can explain my issue.

Using MS Add-ins to upload Invoice data.  A typical invoice has 3-5 lines to it.  Each line has the total invoice amount in, ARH-ORIG-AMT.  The AMD-ORIG-AMT contains the amount that applies to each detail line.

When I upload the data to AR42.2, I receive the following results:

  • Transaction added - distributions out of balance

  • Transaction header record already exists | Transaction changed - distributions out of balance

  • Transaction header record already exists | Transaction changed - distributions out of balance

  • Transaction header record already exists | Transaction changed - distributions out of balance

  • Transaction header record already exists | Change Complete - Continue
  • Here's my issue.  As each distribution line is written, the GL Accouting Unit for the first line is applied for all 5 lines even though each line has a different Category for the distribution.

    Any advice or help is appreciated.

    Jeff

     

     

    Jeff
    Advanced Member
    Posts: 30
    Advanced Member

    Solved the problem.  I altered my add-in spreadsheet to make an invoice and it's detail all one transaction whereas before an invoice was being uploaded as 4-5 lines or transactions.

    Deleted User
    New Member
    Posts: 0
    New Member
    nicely done! and thank you, for sharing w/ the community!
    Jeff
    Advanced Member
    Posts: 30
    Advanced Member
    We came up with another solution this morning that allows a multi-row transaction also. We are able to accomplish this by including blank columns for the form AR42.5 where our issue was. Columns added were _f53r0, _f54r0, _f55r0, _f56r0, _f57r0, _f58r0.

    If others need more detail on this topic, send me an email and we will be glad to share our UWF file for the AR42.2

    Jeff
    John Henley
    Posts: 3355
    You can also post your UWF and sample XLS files to the addins library: https://www.lawsonguru.co...icrosoftAddins.aspx. NOTE: The Addins Library is no longer available. You can download Sample addins files from Infor Download Center.
    Thanks for using the LawsonGuru.com forums!
    John
    Jeff
    Advanced Member
    Posts: 30
    Advanced Member
    Sample files have uploaded to the Add-ins library.

    Jeff