MYOBCommunity
Partner Zone
|
|
Partner Zone

Applying a payment to a sales order through the API

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Contributing Partner JohnSSell
14 Posts
Contributing Partner
Australia
JohnSSell
Contributing Partner

14Posts

0Kudos

2Solutions

Applying a payment to a sales order through the API

We are having an API issue where a payment is not being allocated to the correct account.

 

The data file has the "Sales Linked Account" setting of "I track deposits collected from customers" ticked on.

 

When making a payment and applying the payment to a sales order manually, it automatically posts the payment to the "Liability Account for Customer Deposits".

 

When making a payment and applying the payment to a sales order through the API it posts the payment to the "Asset Account for Tracking Receivables". Note, there does not appear to be a way to control the account it posts to via the API.

 

This is triggered using http://developer.myob.com/api/accountright/v2/sale/customerpayment/ and applying a customer payment to an existing order.

 

Further when Invoicing the Sales Order with payment applied, the Invoicing process assumes that funds were posted to the "Liability Account for Customer Deposits". Making both the "Liability Account for Customer Deposits" and the "Asset Account for Tracking Receivables" become out of balance.

 

 

The API call is using the .NET sdk, we populate:
DepositTo = "Account"
Account = "A business bank account"
Customer uid = "customer for the order"
invoice row
 uid = "order uid"
 amountapplied = "order amount"
 type = "Order"

 

 

To replicate the problem:

  • Select "I track deposits collected from customers" in the "Sales Linked Account" screen, then
  • Create a new sales order manually, then process a payment and apply the payment to a sales order manually, it automatically posts the payment to the "Liability Account for Customer Deposits", then
  • Create a new sales order manually, then process a payment and apply the payment to a sales order through the API, it posts the payment to the "Asset Account for Tracking Receivables", then
  • Review the Transaction Journal for the two transactions, then
  • Invoice both the Sales Orders, then
  • Review the Transaction Journal for the two Invoice transactions.
Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post