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
Piotr Wycichowski
Thanks Gatis, anyway it seems to be reported as bug instead of wish because now it depends on who created task for whom, am I right? /Piotr W....
14:39 15 May 2024
Aldevinas Katkus
Actually a new version of this bug is SL>>Reports>>Periodic customer statement "accumulates" amounts Not sure why it was duplicated, I clicked "submit"only once....
08:09 10 May 2024