Check the hierarchy for the transactions
1 Like
Thanks all for your help tonight.
I will check this in the morning, as I have the part list on my desk.
Dan was close…
Here’s the sections for Misc LINE Charge. The highlighted is for purchase of To Inventory.
As you can see the misc charge will always hit a variance account, and the only GL Control you could implement would be for the supplier.
We tested this out and saw that everything is going to Price Variance from the line.
Now that we know what is going on. Is there a way to configure the rules to use the GL account from the selected code vs. putting everything into Price Variance?
The easy answer is to make individual PO’s (one PO per line item that requires a misc charge)
But if you are only concerned with the charge hitting the proper GL account, just add any charge to the PO header (even on PO’s with multiple lines). The downside is that they’d have to be fixed amounts and manually calculated.
Ideally:
LINE PARTNUM QTY PRICE EXT
1 STOCK01 5 10.00. 50.00
MISC 10% EXP FEE FOR STOCK PARTS TO GL 12-3456
2 JOBPART 3 15.00 45.00
MISC 10% EXP FOR FOR JOB PARTS TO GL 12-6543
Would create the GL trans of 5.00 to 12-3456, and 4.50 to 12-6543
Would have to be
HEADER MISC1 FIXED 5.00 TO 12-3456
HEADER MISC2 FIXED 4.50 TO 12-6543
Something that could throw a wrench into this would be if the receipt Qty didnt match the order Qty, so the misc charge (which should be a % of the line cost) would be that fixed value.
I think we are going to go down the one PO one Line route.
Thanks!!!