Finding the underlying GL number in PO receipts

[rdingman]

We have the matrix setup from item number to category to GL. The problem is that the purchaser may not use the right item number, but when doing the receipt and then the invoice, the only GL number revealed is the clearing account number. Is there any way to have the GL number from the category appear on PO Receipts and Invoices? And even change it? When auditing from the GL system, it is also the clearing number that appears. Difficult to follow.

System is 5.3

 

[jayconverse]

For regular items, join PORCPL.ITEM to ICITEM.FMTITEMNO, then ICITEM.CATEGORY to ICCATG.CATEGORY to get ICCATG.COGSACCT.

For pure cost entries, just display PORCPL.GLACEXPENS.





Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

It is doing the correct accounting, the Category GL accounts do not come into play when you do a PO receipt or invoice.

 

[jayconverse]

Oh, yeah, you're right. I always did get my debits and credits backwards....

Jay Converse
IT Director
Systemlink, Inc.