Hi there. I'm testing out the T&M invoicing in Sage 100 Contractor (version 19.4.52.0), and found something odd. Was hoping there's an option or a fix for this?
If I allocate a part to a T&M job using the Inventory Allocation - it takes the Part's "Average Cost", and populates the column "Costs" in the Inventory Allocation screen. Then on the invoice, it multiplies this average cost by my Material Hidden Markup.
If I need to purchase more of these parts for the job, I would then create a PO, and finally a PO receipt (or A/P invoice). Now in the Job Cost for that part it uses the Part's "Default Cost", which populates the "Price" column in the PO screen. Then, on the invoice, it multiplies the default cost by my Material Hidden Markup.
The obvious issue is then - what if my Default Cost and my Average Cost are different for that part? It will charge different amounts for the exact same part, and will show up with different totals on the T&M Parts Detail Addendum report.
Is there any way to change this in a setting before the T&M invoice computes? I realize I can just go to each job cost and manually override the billing amount if I have the same part on the invoice multiple times, but I'd like to avoid that extra work.
Any help would be appreciated.