I’m noticing that some of my PO releases have the GL Account listed and some do not.
Does this matter?
Anyone know why this is like this?
I was trying to figure out why the GL Recap on the RBNI report has a total without a GL number and it looks like it’s the for the PO releases that do not show the GL account number.
I’ve seen the GL Recap on the RBNI have two totals, one with the AP Clearing GL account and one without the GL and it appears that the figure with the GL is the current month receipts. Don’t know if this helps any…
Epicor 9 doesn’t hold the GL account number in PO releases the way Vantage did. This was done for performance purposes. POs to inventory get their GL account from part classes POs to jobs get their GL account (either subcontract or material) from product groups. POs to other hold their GL account in the TranGLC table. I’ve written a dashboard for payables to use that shows PO release GL accounts regardless of where the GL account comes from. They didn’t trust Epicor to use the correct account. Guess what…they’ve never found one that went to an incorrect account!
There is also a “get default” button on the release tab of the PO Entry screen, that will show you the GL number when you click it, for the specific PO releases. I think the automatic GL numbers don’t show until you click that button, and the manually entered GL numbers will show up without clicking the button. I hope that helps.
So I’m new to Epicor 9, I was in E8, 6 years ago but I have a custom PO report that includes the GL account in one company, I tried to duplicate it in second company changing the report name…everything worked except the GL Account field on the PO report, the relation is setup char01-char03 to key1-key3 as an output in the data def, any help would be great. Another IT person looked at it with me but we were both stumped as of the TranGL table isn’t working from the data def. also I believe it appears an XML was loaded as a dataset in crystal that no longer exists if that’s the cause
/* Update ShortChar01 with PONum for Reporting TranGLC (Before the world ends)
Jason Woods (jawoods@epicor.com)
12/18/12 */
for each ttPORel where ttPORel.RowMod ne “” and ttPORel.ShortChar01 = “”.
assign ttPORel.ShortChar01 = string(ttPORel.PONum)
ttPORel.ShortChar02 = string(ttPORel.POLine)
ttPORel.ShortChar03 = string(ttPORel.PORelNum).
end.
Epicor wrote this custom BPM to add a relation between the tables PORel and TranGL which duplicating the datadef and adding the relation for these fields
The reason you are seeing 2 totals at the bottom of the RNI report is that the total next to the GL Account is what has been posted and the other number is the total that has not yet been captured via the Capture COS/WIP process. Once you run the Capture, you should only have one total at the bottom of the report. Then you will be able to reconcile the report to its GL Account Number.
Another thing that I do with PO Entry is I add a Method Directive such that if someone enters a PO Line for a Buy For type of “Other”, I require that they select a Part Class. In addition to this, I ensure that my Part Class codes have “intelligence” in that expense-type Part Classes start with X or Z or 0 or some particular character. So, the logic is that if TranType = “PUR-UKN”, then check that 1) it has a part class, and that 2) the part class starts with the special character. This prevents someone from buying expense items and inadvertently hitting an inventory account, which will throw off your inventory subledger.
In addition to @PaulMorgan’s joins, you’ll want to put a table criteria on TranGLC to limit the records to just those for PORel. Otherwise you might get a type mismatch. Or you could possibly pull some other TranGLC record who’s Keys happen to match the PO Num, Line and Release.
I hope that helps.
