Hey,
The accounting people would like to have the AR invoices automatically post to different GL accounts based off the product group code. What would be the best way to do this?
Use ProdGroup GL Controls.
Iām not familiar with the financial parts of Epicor, what section of the help documents should I be looking at to figure out how to make a GL control? Or examplesā¦
-
Launch Prod Group maintenance and load the PG you need the GL Control for
-
Select File -> New -> GL Control
-
On the GL Control \ Detail tab, Search for Type Product Group (or type the words āProduct Groupā in for the Type)
-
Right Click in the Control Field and select Open with ā¦ -> GL Control Entry
-
Enter a code for this GL Control. (I use the ProdCode prefixed with āPG-ā) and a Description
-
Select the Account \ List tab
-
Enter the GL accounts to use for the various contexts. (Iām guessing you want SALES)
-
Save and Close GL Control Maintenance
-
Back in product Group Maint, serach for the GL Control you just created.
-
Save the PG
Thatās it.
Now any time that PG is referenced by a transaction that would create SALES, the GL account in the GL Control will overrie the system default.
1 Like
Ah, but the account context they want isnāt on there. They want the AR contextā¦
EDIT: The following, while correct by itself, is not related to the OPās issue. The OP was interested in AR Clearing not AR Invoicing
Sales is the main Context used for AR posting.
Get your hands on the document āEpicor ERP Accounts Receivable - Transaction Hierarchyā
Hereās a page from it:
1 Like
Oh, she made it sound like it posts into Sales and some āAR clearing accountā or āAR holding accountā (canāt remember the exact name) and she wanted to override the GL account for the clearing/holding account and not the sales one.
You are saying they are one and the same?
There is a AR Clearing account. It holds costs from shipments, that havenāt been billed yet.
That one might not be able to be PG group specific.
From the doc: āInventory Transactions - Technical Reference Guideā
-
Use AR Clearing Account ā Select this option when you want shipments to post from WIP to AR Clearing instead of from WIP to COS. When you invoice the shipment, the AR invoice transaction generates. However, an additional inventory transaction moves the financial amount from the AR Clearing account to the COS account. Both of these inventory transactions, WIP-AR Clearing and AR Clearing - COS, post during the Capture COS/WIP process.
The Use AR Clearing Account check box is located on the Modules > Finance > Accounts Receivable >
General sheet.
The GL Control Type āInventory COS and WIPā has an override for AR Clearing:
But I donāt know if that can be attached to the Product Group.
the ACCTS RECV Account comes from the COMPANY AR GLC, or CUSTOMER AR GLC
NOT from the PRODUCT group
NOTE - ACCTS RECV is NOT SALES
IMO - to do (AR by PROD GOUP) you would need a posting rule change - and base it on the invoice line - and account for all other NON-product AR.
Although I donāt know WHY you would do that - (split the AR by product) in the first place
1 Like
I think we are treating different product lines as if they belonged to different companies. I know my pay is divided between different GL accountsā¦
How hard is it to change the posting rules? Is that prone to breaking during updates?
Posting rules arenāt EASY to change - but itās not rocket science .
The syntax is specific to posting rules - and TESTING is KEY!
Unfortunately Iāve never found any real good documentation
I expect the posting rule tech guide is the best you can get
Upgrades are NOT a problem , for minor upgrades I donāt believe any action is necessary
ONLY for major upgrade installs where posting rules are rolled out - action is required
You save off your custom rules - and load them back in
2 Likes
As @amaragni pointed out, why would you want to use different GL accounts for the AR Clearing?
Hereās a basic flow if AR Clearing is enabled:
- Issue parts to job - creates STK-MTL part trans.
1.1 These CR Inventory, and DB WIP - Ship Job to Customer - creates MFG-CUS part trans.
2.1 These CR WIP, and DB AR Clearing - Invoice shipment - No part trans.
3.1 This creates GL trans that CR AR Clearing, DB COS
3.2 The COS acct can be overridden based on the invoice lines Product Group and the PGās associated GL Controls(if any)
(thereās a 50/50 chance I got all the CRās and DBās backwards. Iām dyslexic when it comes to accounting credits and debits)
Well, Iām just a dumb engineer and not an accountant, so I may have got confused on what was actually needed. But if I understand correctly we are basically trying to emulate a multi-company setup without paying for the multi-company moduleā¦
Apparently some time in the past we had a consultant who had it set up the way she wanted, with different product lines being posted to different GL accounts instead of the main AR account. But that broke at some point, and the next consultant made a different (worse) solution that involves copying BAQ results to excel an manually processing them to remove duplicates, and then filter by product lineā¦ usually takes a few hours.
If that makes no sense I can go back and ask about it again, but I am on vacation right now.
The main thing we need to clear up is what what you want to go where.
āARā is a little ambiguous. AR clearing temporarily holds the Cost Of Sales of shipments that havenāt yet been invoiced.
Since you used the words āinvoiceā and āpostingā in the thread title, I assumed you meant during invoice posting. Which moves COS from the AR Clearing to the COS acct (or one dictated by the Prod Grpās GL control)
In this case, do what Calvin suggested but with the GL Controls on the Customer.
Mark W.
I finally got around to making custom posting rules - they seem happy with it. Thanks for pointing me in the right direction.
1 Like
This could be done through setting up different GL Control Codes for different product groups. There is no need for custom posting rules.
Vinay Kamboj
Its not the correct context, I checked.