Skip to content

x Want to ask a question or reply? Click here to join the group.
  • Replies 2 replies
  • Subscribers 19 subscribers
  • Views 116 views
  • Users 0 members are here
Browse Forums
Announcements
1k
topics
170
replies
General Discussion
2k
topics
9k
replies
Intelligence Reporting
380
topics
961
replies
More Content

Order Entry: Inserting Tender Type value on printed Sales Orders Invoices

Bennie Pienaar
Posted By

Learn how to insert the Tender Type value on the printed Sales Order Invoice in Sage 200 Evolution.

Open this link for more information.

Parents

  • I tried this out, found an issue when there's multiple tenders per invoice. E.G. if someone does a payment by two different tender types

    to fix this I did the following:

    1.  Update the join

    LEFT JOIN (
     SELECT
     iInvNumID,
     STRING_AGG(TenderDescription, ', ') WITHIN GROUP (ORDER BY iTenderID) AS ConcatenatedTenderDescription
     FROM _bvPOSXZTenderTxFull
     GROUP BY iInvNumID
    ) XZ ON I.AutoIndex = XZ.iInvNumID



    2. Update the Field Name to be:

    ConcatenatedTenderDescription
  • in reply to Nehal Pi

    Thank you so much for your valuable contribution, Nehal Pi ! Slight smile

Reply Children
No Data

*Community Hub is the new name for Sage City