I have an Inter-Company Customer using a specific AR Code G/L Control. Works fine when invoicing but when I do a cancellation invoice it is using the Product Group G/L control and not the AR Code G/L control attached to the Customers account when posting the cost of sales. Therefore the G/L accounts that were debited on the invoice are not properly getting credited with the cancellation invoice.
Can you enable PE Logging for both AR Invoice and Cancel AR Invoice transactions so that it is easier to see how the accounts are hit?
It might be a bug, a setup issue or maybe it requires customization of the posting rule.
The sales side of the entry seems to be pulling fine. It’s the cost of sales. Epicor had me turn on PE Logger for CosAndWip. Clearly pulling from the product group instead of the AR Code G/L Control. Going to look at setup today as they cannot duplicate on their version of 10.2.600.35. I’m on 10.2.600.8.
I am not that familiar with CosAndWip, do you mind sharing the booking rule being executed that is pulling from the product code and I can more specifically look at changes there.
I don’t mind at all just not sure what is best to share. Attached is the entire log file. Below is a snapshot of the log file pulling the product group. Guidance from Epicor is to upgrade to 10.2.600.35 as they cannot duplicate the error in that version.
Heath Alexander
Chief Financial Officer 
,CPA, CGA Craig Manufacturing, Hartland Branch
T: (506) 375-4535/ 1-800-565-5007 x 535
halexander@craigattachments.com
Website
This email (including attachments, if any) may contain confidential information and is intended for the named recipient only. Please do not forward, copy or otherwise distribute this email without permission of the sender. If you have received this email in error, please notify the sender immediately, and delete this email and any attachments from your system.
2022-02-14 Log file for Cancellation Invoice INVWIPCOS.xml (1.55 MB)
If my analysis is correct this was fixed by ERPS-143870, and later retrofitted to 10.2.600.18 by ERPS-149443.
Before
Rule 1 - Credit Memo = true
Rule 2 - Credit Memo = false
After
Rule 1 - Credit Memo = true AND Cancellation = false
Rule 2 - Credit Memo = false OR (Credit Memo = true AND Cancellation = true)
So now the booking rule executed should call Function “Determine COS Account For COS Detail Using Given Context, Warehouse Division , Plant Division , Sales Category Department” which works as you said(see below).
EDIT
You might be able to fix the posting rule yourself, but it will be a bit more work because you don’t have access to the code which dumps the VBD data.
The steps are
- Create BAQ which retrieves the InvcHead.RefCancelled value, and that accepts InvoiceNum as parameter.
- Go to “Cost Of Sales” posting codes in the tree, and the do New Query, select the BAQ created above, assign the parameter to the “Cost Of Sales - Details - Invoice Num” value.
- Create a new Posting Code under “Details”, select the BAQ and RefCancelled field in the dropdowns.
- Modify the “Selection” criteria for the posting rules “Cost of Sales”, basically if RefCancelled > 0 it means this Invoice is a cancellation.
There probably is a more detailed step by step guide here somewhere, try looking around.
This is in case you don’t want to take an update.
Jonathan, that’s good information!
Is it possible to tweak the posting rules in the current version or is the only option to upgrade to the newer version?
Heath Alexander
Chief Financial Officer
,CPA, CGA Craig Manufacturing, Hartland Branch
T: (506) 375-4535/ 1-800-565-5007 x 535
halexander@craigattachments.com
Website
This email (including attachments, if any) may contain confidential information and is intended for the named recipient only. Please do not forward, copy or otherwise distribute this email without permission of the sender. If you have received this email in error, please notify the sender immediately, and delete this email and any attachments from your system.
See my EDIT in the previous comment, it is possible to tweak only the rule but its kind of complex.