x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 645 views
  • Users 0 members are here
Browse Forums
Announcements
104
topics
4
replies
General Discussion
1k
topics
2k
replies
Andrew1986

Sage 200 creates a new record in the Database after changes data

SUGGESTED
Posted By
Hello Team,
I use Sage 200 API to receive data and sync them with my application.
For receiving AR documents I use the following endpoint - api.columbus.sage.com/.../sales_transaction_views
But, I detected that when I change the Invoice, Credit Notes, Payments, etc. in Sage 200, Sage 200 API returns a new 
{
        "posted_customer_transaction_id": 1592886,
        "transaction_type": "TradingAccountEntryTypeInvoice",
        "transaction_date": "2022-06-22T00:00:00Z",
        "posted_date": "2022-06-22T00:00:00Z",
        "due_date": "2022-07-22T00:00:00Z",
        "discount_days": 14,
        "reference": "FOP2022",
Then, I changed the Invoice
    {
        "posted_customer_transaction_id": 1592918,
        "transaction_type": "TradingAccountEntryTypeInvoice",
        "transaction_date": "2022-06-22T00:00:00Z",
        "posted_date": "2022-06-22T00:00:00Z",
        "due_date": "2022-07-22T00:00:00Z",
        "discount_days": 14,
        "reference": "FOP2022",

As you see the "posted_customer_transaction_id": 1592918.
Could you clarify, which AR document identifier I can use as a unique? Regards, Andrew
  • 0

    We used "posted_customer_transaction_id" as a unique document identifier.

    But, Sage 200 changes it after each modification process.

    Could you explain what field is a unique identifier?

    Regards,
    Andrew

  • 0 in reply to Andrew1986

    posted_customer_transaction_id is indeed a unique identifier.  If you use Sales Ledger / Adjust Transactions / Correct Transactions then look at Sales Ledger Transaction Enquiry you will see that "amending" a transaction reverses the original transaction and adds a new one.  

    I'm wondering why you need to amend posted transactions?

  • 0
    SUGGESTED

    Hi Andrew,

    The posted_customer_transaction_id is the API named equivalent of the SLPostedCustomerTranID for any transaction in the Sage 200 database. This is the unique identifier for any of the transactions that are posted. Depending on the type of correction made (more information can be found here), your transaction may be reversed and reposted - hence the new posted_customer_transaction_id.

    Any further questions, just reply to this post.

    Thank you,

    Ian

*Community Hub is the new name for Sage City