Inventory and Transport Accounting

Overview

With the introduction of the landed cost functionality, we are allocating the transport cost to the Inventory. 

The Accounting will need to be updated to dissuade double entry of the transport cost and inventory. 

We also need to only allocate stock used to Cost of sales. 

Accounting on GR's. 

We need to add accounting functionality on Goods Received (GR) transactions. 

When receiving Stock, we need the GR to do the following: 

• Debit - Inventory - Control, 

• Credit - Accrual - Inventory 

Accounting on SI's

A Supplier invoice can get created from 2 GR Modules. 

GR Goods and GR - LC. 

When the SI is created from these modules, we need the SI to do the following. 

• Debit - Accrual - Inventory 

• Credit - Payables. 

Monthly journals, Move Stock to Cost of Sales. 

Stock Value Increases

Total GR Value for the month. 

Journal to: 

• Increase Stock. 

• Decrease Cost of Sales. 

Stock Value Decrease

Total Issued from Inventory Module.

Journal to: 

• Increase Cost of Sales

• Decrease Stock

Questions/Updates.

• Purchase Goes straight to inventory. 

• Monthly Journals, Per Inventory Item, ie. Wants to see why a single item affects the Cost of Sales so much.  

  • Automate the Monthly Journal. 

  • Goods Issued - Cost of Sales - Later (

  • Stock Check tells what actual Stock is.  - Include as Cost of Sale. 

  • Monthly - 

Bumatech Review. 

• What is causing The Cost of Sales difference. 

• What is the cause of the difference between the Theoretical vs Actual Stock.

To Do

• GR Checklist to see if Account is correct. Debit and Credit. 

• Update Checklist on REQ to make sure that the correct Debit Account is selected when Transport - GR and Cost of Sales.