Last Cost Price

Created by Datapel Integration, Modified on Fri, 6 Jun at 4:25 PM by Datapel Integration

Description

This article gives an overview how WMS calculates last Cost and why it may show a different value than your accounting system.

Detail Steps

Case 1

The CloudWMS holds the last replicated cost from your accounting system. If the value is showing incorrectly you may need to run a system replication.

What is Replication? | Datapel Help Center

Case 2

Your items are setup with GST buying tax code but you normally purchase your items tax free.

Accounting software Last Purchase price shows as $1.067014
Tax Code When Bought is set to GST (Goods and Service Tax) 10%

In WMS Item shows as $0.9700

Why does WMS and MYOB show different Last Cost?

The buying code on the item in the accounting system is GST.
When reading the item details from the accounting system the WMS is unable to see if the Last Purchase for the item used the GST tax code.
The system has to assume the tax code on the item was used.
WMS uses the price provided less 10% tax (1.067014/1.1=0.9700127272)

Solution

Update the items default tax buying code in your accounting system to N-T/Free if you usually buy those items tax free.

Related Information

This article refers to the MYOB accounting system, however, this article is applicable to all accounting systems connected to the CloudWMS.