x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 17 subscribers
  • Views 810 views
  • Users 0 members are here
Browse Forums
Announcements
238
topics
27
replies
General Discussion
1k
topics
3k
replies
Intelligence Reporting
311
topics
786
replies
Wouter van Aswegen

SDK where do I find payments linked to invoices

SOLVED
Posted By

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.

Parents
  • 0

    Good day Wouter,

     Please forward your query to [email protected].  Our support team will log the incident with SDK support to assist you further. 

     Kind Regards.

  • 0 in reply to Lolo

    Lolo

    It is now 11 days later and SDK support has not replied. As per your suggestion I also sent an email to supportsa, but other than the automated reply, nobody has replied yet.

    It is impossible to work like this. Is there ANY way to escalate this, because every avenue I have tried resulted in nothing. I have sent emails, called the support line, used the online chat, logged it here on SageCity, but it seems as if there is no way to get SDK support, everyone says I have to send an email to sdksupport (which obviously doesn't do anything). I have even contacted my account representative, who provided me with an email address of somebody at sdksupport, but that email was never answered.

  • 0 in reply to Wouter van Aswegen

    Haha, welcome to the new way Sage does support.

  • +1 in reply to Wouter van Aswegen
    verified 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 ‘linking’, 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.

Reply
  • +1 in reply to Wouter van Aswegen
    verified 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 ‘linking’, 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.

Children

*Community Hub is the new name for Sage City