• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

AR Invoice Distribution

 5 Replies
 2 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Jeff
Advanced Member Send Private Message
Posts: 30
Advanced Member
4/15/2009 1:27 PM

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 Send Private Message
    Posts: 30
    Advanced Member
    4/15/2009 6:34 PM

    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 Send Private Message
    Posts: 0
    New Member
    4/15/2009 6:55 PM
    nicely done! and thank you, for sharing w/ the community!
    Jeff
    Advanced Member Send Private Message
    Posts: 30
    Advanced Member
    4/16/2009 2:40 PM
    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
    Send Private Message
    Posts: 3351
    4/16/2009 3:10 PM
    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 Send Private Message
    Posts: 30
    Advanced Member
    4/16/2009 3:46 PM
    Sample files have uploaded to the Add-ins library.

    Jeff