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

SUGGESTED
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
Parents Reply
  • 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?

Children
No Data