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
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
    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.

      MTFF
      Veteran Member
      Posts: 50
      Veteran Member
      4/15/2009 6:55 PM
        nicely done! and thank you, for sharing w/ the community!
        Jeff
        Advanced Member
        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
          Posts: 3353
          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
            Posts: 30
            Advanced Member
            4/16/2009 3:46 PM
              Sample files have uploaded to the Add-ins library.

              Jeff