Hi all,
Ive been attempting to set a default customization for the CashDtlTGLC.GLAccount field on AR Write Off and Adjustment to no avail. I’ve tried to use a dataview through the wizard, but it wont populate. I also havent figured out how to refer to GLAccount through an in-transaction data BPM, since I only have access to the CashDtl table, not the CashDtlTGLC. What am I missing here?
Thanks for any and all help!
I think the GL tables are best addressed via GLControls, and not BPM’s.
Thanks for the quick response!
Sorry I should’ve been more clear, we are not trying to create a new GLAccount or manipulate an existing one, we are only attempting to set a default value for a field in a specific menu. We were initially hoping we could set it in the company configuration menu, but are not able to do so according to epicors support.
Of course, if I misunderstood your point, let me know!
I second what @ckrusen said. If you provide more information about what exactly you are trying to do (e.g. transactions, GL Control Code, etc.) I think we will be able to answer you better.
According to the AR Heirarchy Guide, a write off uses the following:
I’m guessing its the “Enter Account Number on Record” that you have to fill in each time, and want it to have a default. That correct?
Thanks for sharing that resource, that is exactly what I am attempting to do. I’m not familiar with this side of epicor, so that graphic did help. Im getting the gist I’m not understanding the use case of GL controls for this scenario. Think you could enlighten me a bit? I really appreciate the help from both of you so far.
Every “default” GL account that is used is specified by a GL Control. What I mean by “default” is that a specific account will be used for specific conditions. Even the most core GL accounts (like your Raw Materials Inventory Acct) must be specified somewhere. These core accounts are usually company specific. So they are specified in the Company Maintenance (or is it Company setup? I can never keep those two straight). They are set by using GLC’s (GL Controls).
GLC’s can be very confusing at first. A GLC is attached to a specific business usage, consider these as GLC Types. Some example GLC Types are:
(there are probably somewhere between 50 and 100)
Within a Type GLC will be several contexts. For example, the “Inventory COS and WIP” there are contexts like what is shown below:
The highlighted line shows the GL account to use for the Inventory context of the “Inventory COS and WIP” type. What is not shown is that this is just one of several settings for the “Inventory COS and WIP” type. This one happens to be named “Inv COS Default” (a name I chose).
Now I have a defined GLC. It has the following properties:
Now anywhere a GLC of type “Inventory COS and WIP” can be applied, I can select my “Inv COS Defaults”. But you don’t want to just use it all over the place. You want to understand the hierarchy and set his only where it needs to override another GLC - or at the most basic level, as there are no default GL accounts.
The only place I need to use this GLC is in Company Maintenance. That sets the “default” GL account to use for Inventory transactions.
If there are circumstances where i don’t want an inventory transaction to go the Inventory GL account, I can create other GLC’s that can be used to override the base ones. An example would be best.
Say you have a SHop supply that you want to track the QOH, but it is to be expensed upon receipt. Making it a Qty Bearing in part master will enforce track qty transactions. However, it will also default to your main Inventory GL Control. To make the transaction hit the desired expense account instead of the Inventory GL, do the following:
PartClass
SHOP
SHOP EXP (5160) (I like to put the GL acct in the description)5160-00-01
SHOP
Now when you receive that part on a PO, it hit 5160-00-01, instead of 1151-00-01.
It’s a lot to take in. You best bet is to experiment in a test environment.
If I could upvote something multiple times, I would. That write up was ridiculously easy to comprehend, so thank you for that.
After diving into GL Controls, I couldn’t find a type that had a context that would fit AR Write Off and Adjustment. Is there a way to tell what context a GL account field would use? (Forgive me if Im using these terms incorrectly, a lot of this is new)
When I was trying to see if the Field Help had a context section for GL account, I also went into the application help for AR Write Off. In it, Epicor says this:
Does this mean I just got unlucky and have a spot in Epicor where GL Control isn’t
viable? Or is going through GL Control considered “user defined”?
Again, cannot stress enough how helpful you have been 
I spent more time than I would like to admit trying to do this through custom code.
The “Hierarchy” documents available on Epicor’s support site explicitly list the GL Control that will dictate which Acct will be used… From the AR Hierarchy:
The decision method works by by seeing a GLC exists for the types/contexts listed in order. If one is found (and has a non-blank account specified) then the account specified by the GLC will be used.
In the above, to determine the GL account for the Debit, it would first check to see if there is an AR Account GLC attached to the customer. If there is (and the acct in that GLC is not blank), it will use that GL account. If no GLC existed on the customer record, It uses the GLC applied in Company Configuration.
To determine the acct for the Credit, It would first check for a GLC setup on the Product Group. Note that it is using the Prod Group that is on the invoice line, which may differ from the Prod Group set for the part in the Part Master). If that didn’t exist, it then checks to see if the Customer’s Sold To has a GLC. And so on, with it “defaulting” to the settings in the GLC applied in the Company Config.
