Client is going over their month end and have found a problem with the AR/OE clearing account. The totals match in OE however an item on some invoices don't show up in the AR account.

Hi Andy,

Over the years I have always found that the AR/OE Clearing account clears unless:
1. The corresponding GL batch to come from AR hasn't been retrieved and/or posted yet
2. Something other than the normal OE/AR posting has accidentally posted entries to this clearing account

If I take your statement literally, it's interesting that you say that "an item on some invoices don't show up in the AR account" as usually the invoice total rather than line item details is what flows over to the AR account. Maybe what you meant is that some invoices are showing up in customer accounts and not others.

Is it possible that a few transactions got entered with the wrong date and are not being day ended when you would expect them to be ?

Pete

Hi,
If the same item on various invoices is difference in the OE-AR Clearing account, it sounds like there could be a category configuration issue, where one of the sales or cost of sales accounts in the Inventory Category table is pointing to the OE-AR clearing account.

This would effect the GL distribution by netting against the total invoice value for the source entry coming from OE.

Check your category code in Inventory for said item(s) and confirm that the GL account distributions for that item are correct, and revise as necessary.

Best,
Brian