Question on Billing a Sales order from Item Fulfil...
# accounting
p
Question on Billing a Sales order from Item Fulfilment: Our SOs contain seralised inventory. Lets say two lines.... Line1: ITEM A; Qty10 all serialised Line2: ITEM B; Qty12 all serialised That SO may have several item fulfilments against it. IFUL#1: Line1: ITEM A; Qty 5 all serialised Line1: ITEM B; Qty 2 all serialised IFUL#2: Line1: ITEM A; Qty 5 all serialised Line1: ITEM B; Qty 10 all serialised Currently, when we BILL from the IFUL#1, the whole SO gets billed so we have to amend the QTYs on each line of the invoice, and amend the serial numbers. We want to be able to press BILL on IFUL#1, and an invoice be generated to based on the items on that IFUL, so in this case Line1: ITEM A; Qty 5 all serialised Line1: ITEM B; Qty 2 all serialised Is this achievable for workflow or script?
r
There's an option in Accounting Preferences to "Invoice in Advance of Fulfillment." Looks like you have that on. Shutting that off should fix this issue, no workflow or scripting needed. Disclaimer: I would of course test this in Sandbox against unrelated processes as well to ensure you're not going to mess up other things. I'm a little surprised everything gets billed when you hit Bill from the IF. I would expect that to happen if you'd do it from the SO, but I was thinking Bill from the IF only Invoices things on that IF. Bad memory I guess.
k
Bad memory there. It definitely just bills the SO
You might be able to hide the inventory detail field on your invoice to get around this.
p
@KevinJ of Kansas Great advice, thanks. Invoice in Advance of Fulfilment is disabled. They are InterCompany SOs, IFULs and Invoices which always muddies the water. Also, apparently ACS looked into this last year (before my time) and they hit a wall. But then again, ACS have not been great for us IMHO.
k
ACS is very hit or miss
p
Mainly miss for us!
k
This get you past your error then?
p
No
:-(
k
In theory this could be scripted. I'd expect it to be pretty painful though and a little buggy
and would probably involve someone hitting a button on the item fulfillment and then editing the invoice to fix anything you chance at that point
(i.e. it would save the invoice in the background)
My spitball estimate in the air is that the code itself isn't that hard to write - but dealing with all the edge cases and problems and you could be looking at 70-100 hours total.