Sales Item / Service incorrect

Question

Hi,&nbsp;I have developed a small application that pulls data using the API to generate a timber cut list for a client.&nbsp; This has been working fine until recently where I have found that I am missing some Invoice Numbers.&nbsp; I have identified the issue as that the Invoice Number shows if I call&nbsp;http://localhost:8080/accountright/cf_uri/Sale/Order/service/?$top=1000but nothttp://localhost:8080/accountright/cf_uri/Sale/Order/item/?$top=1000&nbsp;When I look at the affected Invoice Numbers in the sales register the Layout is set to Item and everything appears correct.&nbsp;If I call http://localhost:8080/accountright/cf_uri/Sale/Order I am able to see the invoice numbers are listed as&nbsp;"URI": "http://localhost:8080/AccountRight/cf_uri/Sale/Order/Service/uri",&nbsp;I have attempted to recreate from the original quote the Invoice however each time it becomes a service rather than an item.&nbsp; This is further an issue as the service fails to return values for UnitCount which prevents me from correctly generating the required cut lists.&nbsp;Is there a way to force an Invoice to be an Item rather than a Service?&nbsp; It should be an Item in the first place.&nbsp;&nbsp;Thanks&nbsp;

dlarosa · Answer

I am experiencing a nearly identical issue with Purchases. Within the MYOB application, it is an Item Purchase Order with an item line, but through the API it does not come through the ItemPurchaseService, it comes through the ServicePurchaseService.. and as the original poster mentions, the lines from the API do not contain item codes because the API believes it is a ServicePurchase. In addition, it also comes through the generic PurchaseService, but with order type "Service".

I need access to the Item Lines.

All other Item Purchase Orders come through correctly, not sure why the API believes this particular Purchase is a Service Purchase.

john_dinning · Answer

Have a look at this thread and see if it is of any use (even if it only confirms the problem).

https://community.myob.com/t5/MYOB-API-questions-and-answers/Purchase-Order-Type-Mismatch/m-p/606769#M3871

dlarosa · Answer

Hi John.. Thanks for the link... Last week, I stumbled across the issue you bring up on that post, but as you mention, it's a simply fact of ignoring it. In other words, I assumed that the ItemPurchase endpoint returning ItemPurchase objects with the status of Service was just a bug.. This did not prevent me from using the ItemPurchaseLines as they were all correct. So even though, the ItemPurchase had a status of "Service", this was easy enough to ignore and still do work we required. I have no trouble processing the majority of our purchases.

The issue I am describing, and also described on the post by the poster that you link is a different issue than just an incorrect status. Namely, no purchase is returned when querying the ItemPurchase Endpoint for a specific item purchase. The only way to get the purchase, is by querying the ServicePurchase endpoint, or the Purchase endpoint.. both of which don't give you lines you can use.. I am yet to find the specific conditions for a purchase to get incorrectly placed via endpoint... funnily enough, after conversion to bill, it then gets correctly positioned, in other words, i can successfully get it from the ItemBill endpoint.

john_dinning · Answer

Ah ok. So you are having this problem with one particular Item Purchase Order and not all of them is that correct?&nbsp;I am using the SDK/API and am able to return an Item Purchase Order (and its lines) using the&nbsp;ItemPurchaseOrderService and&nbsp;ItemPurchaseOrderSvc.GetRange with this filter (e.g.):$filter = Number eq '00000012'&nbsp;I have not noticed it fail yet, but that doesn't necessily mean that it hasn't.&nbsp;&nbsp;&nbsp;

dlarosa · Answer

Hi John. Correct, the problem is only with some Item Purchase Orders. Out of the last 30 Item Purchase Orders, I have had the problem with about 3 of them.&nbsp;Like you, we are also using the ItemPurchaseOrderSvc.GetRange function.. filtering specifially for the invoice number like you mention... it returns nothing for the problem item purchase orders... because of this, I went hunting for it, and found out it returns from the ServicePurchaseOrderSvc instead.

Forum Discussion

Sales Item / Service incorrect

Looking for something else?

Related content

Long Service Leave Incorrect Balances

Incorrect Long Service Leave

Incorrect Due date on Sales Invoice

Importing Sales Service Invoices with no amounts -URGENT PLEASE

Sales - Service - Import Errors 14 and 1019

Incorrect Billing

Payroll YTD figures are incorrect.

Incorrect GST