Information Systems:Journal Entries
Generated
G/L entries are automatically generated by sales, receiving, and transactions in the warehouse. To see how this is done, key 81 on an ASW command line, and press enter.
*PL/480B* Table maintenance program selection 12/02/14 17:48:36 ASGD0181
-------------------------------------------------------------------------------
Appl Table
_ AAC G/L transaction types
_ AAC Transaction origins
X DIS Transaction types
_ FIN Transaction enquiry sequences
_ GEN Nature of transactions
-------------------------------------------------------------------------------
Appl Search argument
transaction
Key in a search argument of ‘transaction’, and press enter. Select ‘Transaction types’.
*PL/480B* Transaction type table maintenance 12/02/14 17:51:09 DMR0271
-------------------------------------------------------------------------------
Type Description
350 RF adjustment up 350
351 RF adjustment down 351
800 Cost for goods sold 800
801 Cost for goods del. FOC 801
802 Coin adjustment 802
803 Accounts receivable 803
806 Surcharge 806
810 Purchase accounts(sys req) 810
811 Exchange rate diff invoices811
812 Quantity diff invoices 812
813 Price diff invoices 813
814 Invoiced purchases(sys req)814
840 Gross sales 840
841 Line discounts 841
842 Order discount no VAT 842
843 Sales val inv. n del no VAT843
844 Line disc inv. n del no VAT844
845 Order disc inv. n del 845
846 Freight no VAT 846
847 Postage no VAT 847
848 Insurance no VAT 848
849 Administration fee no VAT 849
850 Invoice fee no VAT 850
901 Stock value 901
902 Stock value-Drop-Transit 902
903 Stk val fict.item 903
904 "Stock" value direct del. 904
907 Goods in transfer-IRO 907
910 Manual average cost change 910
911 Manual av.cost chg.tran BtB911
912 Stock take difference pos 912
913 Stock take difference neg 913
915 Average cost change 915
916 Average cost chg. tran BtB 916
917 "Stock" value no stock upd 917
918 Stock supply diff. pos 918
919 Stock supply diff. neg 919
930 Reception from supplier 930
931 Return to supplier 931
936 Reception from supplier FOC936
944 Rnd diff - cost price calc 944
945 Gain/loss, returned goods 945
960 GST payable 960
961 GST payable on hd fees 961
962 GST payable on surcharges 962
963 GST payable on kits 963
969 Invoice rounding difference969
1000 MAI Destroyed inv (int) 1000
1001 MAI Missing items (int) 1001
1002 MAI Precursor Destruction 1002
1010 MAI Destroyd inv(ext-narc)1010
1020 MAI Destroyed inv(ext-phx)1020
1030 MAI Destroyed inv(ext-oth)1030
1035 MAI Inventory transfers 1035
1040 MAI Cycle Count Adjustment1040
1043 MAI Unit of Measure Adj 1043
1045 DO NOT USE
1050 PST payable 1050
1051 PST payable on hd fees 1051
1052 PST payable on surcharges 1052
1053 PST payable on kits 1053
1060 HST payable 1060
1061 HST payable on hd fees 1061
1062 HST payable on surcharges 1062
1063 HST payable on kits 1063
1100 CGY Destroyed inv (int) 1100
1101 CGY Missing items (int) 1101
1110 CGY Destroyd inv(ext-narc)1110
1120 CGY Destroyed inv(ext-phx)1120
1130 CGY Destroyed inv(ext-oth)1130
1135 CGY Inventory transfers 1135
1140 CGY Cycle Count Adjustment1140
1143 CGY Unit of Measure Adj 1143
1145 CGY Returns to Main 1145
1997 test
-------------------------------------------------------------------------------
Type
This is a list of all the transaction types that can be automatically generated by activity. ‘Types’ of 1000 and more are ones that we have created.
To see how the G/L entries are generated, select a transaction type.
*PL/480B* Transaction type table maintenance 12/02/14 18:19:33 DMR0273
-------------------------------------------------------------------------------
Type................ 800
Description......... Cost for goods sold 800
Valid tables
Summarise trans..... N 01 Item account group
VAT handling code... USST 02 Item group
Account part 1...... 01 03 Customer account group
Account part 2...... DI 04 Customer group
Account part 3...... OP 07 Warehouse
Account part 4...... WA 08 Area
Account part 5...... 09 Salesman
Account part 6...... 10 Handler
Account part 7...... 11 VAT
Account part 8...... 12 Currency
VAT override........ N 13 Sales order type
VAT account......... N 15 Acc. group, item/parent
Balance type........ 16 Item group, item/parent
Trans cost calc code 23 Project cost code 1
Transaction cost.... 28 Project
45 Project cost code 2
99 Cost center
F8=Accounting information
This shows how each account part is constructed. The two character alpha codes are ‘fixed accounts’. These point to ‘pseudo accounts’, which in turn point to the G/L master file. Pointers are used here instead of the actual G/L numbers, so that the G/L structure itself can be changed without having to change all of the ‘transaction types’. However, the way we have implemented it does not support this functionality. We have named our pseudo accounts as the account part number, then the account number itself. For example, the pseudo account for pharmaceutical cost of goods sold is ‘1410000’. For pseudo accounts to actually work as designed, it would have to be something like ‘RXCOGS’.
If the code is a number, then ‘Valid Tables’ indicates criteria. Press F8 for more information on this.
*PL/480B* Accounting information 12/02/14 18:22:55 DMR0411
-------------------------------------------------------------------------------
Type................ 800 Cost for goods sold 800
-------------------------------------------------------------------------------
Acc.p Code Description
X 1 01 Item account group
2 DI Distribution
3 OP Operations
4 WA Warehouse - Main
Select Account Part 1. Because this is code 01, every item account group shows, and allows a pseudo account to be entered against it.
*PL/480B* Accounting information 12/02/14 18:24:26 DMR0413
-------------------------------------------------------------------------------
Type................ 800 Cost for goods sold 800
Account part........ 1 Item account group
-------------------------------------------------------------------------------
Code Description Pseudo
C100 Customer _______
C200 Vendor _______
I100 Pharmaceuticals 1410000
I200 Home Health Care 1410100
I300 OTC 1410200
I400 Health & Beauty 1410300
I500 Sundries 1410400
I600 Tobacco 1410500
I700 Non-Stocked & Seasonal 1410600
Z001 Dropshipment (1120) _______
Z002 Drop Shipment Admin Fee (1120) _______
Z004 Enclosure Admin Fee (1120) _______
-------------------------------------------------------------------------------
By looking at the fixed account and pseudo account tables, we can that when an OTC item is sold, cost of goods sold will be posted to 410200 1000 1100 1120.