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.