Re: GP per location
Kaido Schmidt
5-31-22
Hey Paul,

if you have settings like this:
- stock-settings-cost model - tick FIFO Per Location and tick Weighted Average per Location
- sales orders-setting-order setting - update cost price on order when delivering
- stock-settings-cost accounting - cost price at invoicing - from sales order

then create a new sales order and paste item will paste cost price from item card and calculate GP according to cost price from item card at this stage

then create delivery and ok and save - this takes item out of stock according to FIFO or WA in that location, and updates order row cost price to that location FIFO or WA at the time of OK and save delivery as well

then create invoice from delivery or from order - it copies the cost price from order row (which is the FIFO or WA for that location that delivery took the item out of stock with) and paste on invoice row as well.

so
- GP invoices in this case is always calculated based on FIFO or WA in that location (need to invoice after each delivery though)
- GP orders is a bit mix and match, dependent on if you have delivered the order or not, or if you have part delivered several times and at different FIFO or WA cost at the time of delivery
- GP quotations is always cost price from item card though...

Kaido
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Lilian Wanyoike
Hi, Spinners & Spinners are currently on version 8.5 2022-02-02 (build 85420830). they have been experiencing a network lag. Action taken: - Checked logs and confirmed that they had not whiteli...
14:13 30 Aug 2024
Lilian Wanyoike
Hi, Spinners & Spinners are currently on version 8.5 2022-02-02 (build 85420830). they have been experiencing a network lag. Action taken: - Checked logs and confirmed that they had not whiteli...
14:13 30 Aug 2024