LineAmount on Invoice transaction doesn’t match Sales Lines table

  • LineAmount on Invoice transaction doesn’t match Sales Lines table

    Posted by DSC Communities on December 18, 2017 at 1:13 pm
    • Daniel Zook

      Member

      December 18, 2017 at 1:13 PM

      A recent transaction from Retail POS shows a different line amount in the Invoice Journal lines than it does in the Sales Lines.

      In Sales Lines, the line amount is $17.99, as shown here:
      Sales Lines
      In the Invoice Journal, the line amount is $13.99.

      Has anyone seen this before?Ā  Do you have any suggestions on what might have caused this?

      ——————————
      Daniel Zook
      Director of IT
      Lehman’s
      Dalton OH
      ——————————

    • Tony Zeigler

      Member

      December 19, 2017 at 3:20 AM

      Normal flow for pricing:
      Sales line –> SalesParmTable –> CustInvoiceTrans
      Could be that someone or something over-rode the price while performing the posting?
      Check the value in the salesparmtable if it hasn’t been deleted…

      There is also a possibility – although smaller – that someone changed the salesline during the invoicing process.

      ——————————
      Tony Zeigler
      Strategic Solutions NW, LLC
      Beaverton OR
      ——————————
      ——————————————-

    • Daniel Zook

      Member

      December 21, 2017 at 1:15 PM

      Thanks for the suggestion.

      I don’t think anyone over-rode the pricing / line discount since all the information flows automatically from Retail POS directly into a sales order and then invoicing, which are all automated processes that are standard AX.

      For some reason though, the line discount of $2 *added* to the total in the sales order, but *subtracted* on the Invoice.

      If anyone else has any thoughts, please share.

      Thank you.

      ——————————
      Daniel Zook
      Director of IT
      Lehman’s
      Dalton OH
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 10 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘LineAmount on Invoice transaction doesn’t match Sales Lines table’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!