Finding a Warehouse to Find an Account Recognition Code

There are two types of ledger interface: Inventory and Transactional.

Inventory Type

If an inventory type of ledger interface uses a warehouse type of account code recognition, SunSystems looks at the receipt or issue for the location. Once the location is found, SunSystems looks at the location setup to find an associated warehouse. From this warehouse it finds the relevant account recognition code, and hence the account code to be used for the ledger posting.

Transactional Type

If a transactional type of ledger interface uses a warehouse type of account recognition code, SunSystems looks at the relevant transaction to find the warehouse. For example, if a warehouse is entered on a sales order line or a movement order line, then this is the warehouse that is used. In purchase orders there is no warehouse field, so transactional type of interfaces do not work here. SunSystems looks at the exact stage that the ledger interface is associated with. The following shows where the relevant warehouse is found:

Module Stage Location Used
Purchasing All stages Not applicable
Sales Order Entry Warehouse on order line
Order Acknowledgement Warehouse on order line
Picking Warehouse on order line
Picking Confirmation Warehouse on order line
Despatch Warehouse on order line
Despatch Confirmation Warehouse on order line
Sales Invoice Warehouse on order line
Inventory Order Entry Receipt To Warehouse on order line
Order Entry Issue From Warehouse on order line
Order Entry both Receipt and Issue, or neither To Warehouse if it exists, otherwise the From Warehouse
Order Confirmation Warehouse on order line
Receipt Note Entry/Matching Not applicable
Picking From Warehouse on order line
Picking Confirmation From Warehouse on order line
Despatch From Warehouse on order line
Despatch Confirmation From Warehouse on order line

Regardless of ledger interface type, if a warehouse is not entered on a transaction, or the issue and receipt are not actualised, SunSystems fails this level of checking and searches the next level. The next level is specified as the substitute account recognition code on the Ledger Interface Account Recognition Codes.