SDK where do I find payments linked to invoices

Question

I am using Pastel V19 SDK to draw data because the client requires specialised Customer Statements. Using the ACCTRN combined with the ACCMASD files I can get all the transactions that must be displayed on the statement (I had to import from previous year files to ensure I had the correct opening balances). 
 On Pastel the users link payments to specific invoices, which results in the Pastel statement pairing payments to invoices. 
 Does anyone know where I can find this payment to invoice link in the data using the SDK? 
 I have sent an email to sdksupport, but they take a very long time to respond (weeks), and sometimes doesn't respond at all. 
 Any assistance will be welcome.

Lolo · Accepted Answer

Good day Wouter, 
 Linking or Matching of Payments to invoices would depend on the Customer setup in Sage Pastel. 
 If the customer is set up as Balance Forward, there is no &lsquo;linking&rsquo;, and payments are matched from the oldest to the newest invoice. 
 For Open Item Customers, payments are matched to invoices and this can be queried in the Open Item (accoi.dat) table. 
 In the table, the Original column will be 5 for Credit Notes and Payments and the MatchRef column will indicate which document the Payment has been matched to. The column will be blank if the payment remains unmatched. 
 Kind Regards.

Sage 50cloud Pastel

SDK where do I find payments linked to invoices

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING