If you notice that the General Ledger (GL) posting of a sale for a particular product or service on an invoice line is not as you expect, then follow the steps below.
Check the Product or Service Masterfile GL Set
Check that GL Set field value is correct from Products, Masterfiles, Products or Services, Maintain, Details tab.
Note down the GL Set code value. The GL accounts for Sales, COGS and Inventory for an invoice line default to the GL accounts specified in the GL Set Code on the applicable Masterfile.
View the GL Code/Set entered on the relevant invoice line/s to check if it was changed
Go to Customers, Transactions, Invoices, Look Up.
Enter the Customer code and then the invoice number in the Number field.
Click on the invoice line, then click the Zoom In(F8) button and check the General Ledger task area. The related GL Set and GL Account code details entered in the invoice will display.
Note: If you don't see any GL codes or sets, check the screen design you are using.Note down or take a screen shot of these values.
Go to Setups, General Ledger, General Ledger Sets, Enquire.
Enter the Set code as per the Product Masterfile GL Set value and click Enter.
Click on the Balance Sheet and Miscellaneous tab.
Compare the GL codes from the Invoice values at Step 3 above to the ones on the GL Set enquiry screen as per step 7. If they are different, then the GL accounts were overwritten when entering the invoice.
Notes on Screen designer and Sundry Lines
The Screen Designer layout for a sales invoice can have the sale account, as well as other general ledger account fields marked as editable, and so the general ledger accounts typically set by the applicable general ledger sets can be overridden. Consider changing your invoice screen design for the future: Make the required changes in Screen Designer so that the sales GL accounts cannot be overridden.
Sundry lines: For sundry lines the sale account is either manually added on the invoice line itself or will be sourced from the Customer Masterfile GL Set field. You can see this field from Customers, Masterfiles, Customers, Enquire, Account Details tab, General Ledger Defaults task area, GL Set.