This document describes what accounting settings you have to define before you can transfer sales ticket information from an external point of sale (POS) system and update the general ledger in M3.
Accounting events and rules for how to update the M3 general ledger with sales ticket information are defined.
The general ledger in M3 is updated with sales ticket information according to the set rules. The accounting events and rules reserved for sales tickets are automatically retrieved when the general ledger is updated.
The following files are updated:
Enter new FAM functions
Start 'FAM Function. Open' (CRS405/B).
On the B panel, press F14=Standard to generate the default FAM functions.
The following FAM functions will be used for sales tickets:
OP20-Sales ticket invoicing
OP40-Sales ticket petty cash
Select a FAM function and select the Details option to proceed to 'FAM Function. Open Details' (CRS406/E).
If necessary, enter voucher series, voucher name and from and to dates. Press Enter and (CRS405/B) will be displayed.
Repeat steps 3 and 4 for the remaining FAM functions if you need to add new information.
Enter new accounting events
Start 'Accounting Event. Open' (CRS375/B).
On the B panel, press F14=Standard to generate the accounting events.
The following accounting events will be used for sales tickets:
OP20-Sales ticket and refunds
OP40-Petty cash expenses
Enter new accounting type
Start 'Accounting Type. Open' (CRS385/B).
Press F14=Standard to generate the accounting types.
The following accounting type will be used for sales tickets:
701-Petty cash expenses.
Enter new accounting rules
Start 'Accounting Rule. Set' (CRS395/B).
Press F14=Standard to generate the accounting rules. The following accounting events and accounting types are connected:
|Accounting event||Accounting type||Description|
|OP05||904||Sales ticket return-customer return not inspected|
|OP05||910||Sales ticket return-inventory|
|OP10||910||Sales ticket delivery-inventory|
|OP10||951||Sales ticket delivery-delivered, not invoiced|
|OP20||101||Sales ticket invoicing-cash payment|
|OP20||111||Sales ticket invoicing-VAT payable 1|
|OP20||112||Sales ticket invoicing-VAT payable 2|
|OP20||120||Sales ticket invoicing-revenues|
|OP20||131||Sales ticket invoicing-discount 1|
|OP20||132||Sales ticket invoicing-discount 2|
|OP20||133||Sales ticket invoicing-discount 3|
|OP20||134||Sales ticket invoicing-discount 4|
|OP20||135||Sales ticket invoicing-discount 5|
|OP20||136||Sales ticket invoicing-discount 6|
|OP20||951||Sales ticket invoicing-delivered, not invoiced|
|OP20||971||Sales ticket invoicing-cost of sold goods|
|OP30||370||Advance payments-bank account|
|OP35||100||Invoice payments-accounts receivable|
|OP35||101||Invoice payments-cash payment|
|OP35||111||Invoice payments-VAT payable 1|
|OP35||112||Invoice payments-VAT payable 2|
|OP35||301||Invoice payments-realized exchange gains|
|OP35||302||Invoice payments-realized exchange losses|
|OP35||310||Invoice payments-cash discount given|
|OP40||211||Sales tickets petty cash-VAT receivable 1|
|OP40||212||Sales tickets petty cash-VAT receivable 2|
|OP40||701||Sales tickets petty cash-petty cash expenses|
Select an accounting rule and select Change to proceed to the E panel.
On the E panel, specify the accounting strings.
If necessary, fill in a control field on the F panel and enter exceptions in 'Accounting Exception. Open' (CRS396), which you can start by selecting the related option=Exceptions in (CRS395/B).
Repeat the procedure from step 11 onwards for remaining accounting rules and click Close to finish.