<@U6SNW6BC3> what happens when you applied the cre...
# suitescriptt
Tim Pilgrim
10/12/2020, 10:33 PM@mrob what happens when you applied the credit against the invoice? doesn't it net out?
m
mrob
10/12/2020, 10:34 PMI'm sorry I'm not sure exactly what that means. When we apply the credit against the invoice and then create a new invoice off the purchase order the quantity invoiced on the PO has not been updated to reflect the credit.
mrob
10/12/2020, 10:39 PMStrangely, I just loaded up a random PO and i'm not even seeing the quantitybilled field on the line items...
mrob
10/12/2020, 10:44 PM Copy code
rec.getSublistFields('item').filter(el => el.match(/quantity/))
=> (3) ["initquantity", "origquantity", "quantity"]
rec.isDynamic
=> true
rec.type
=> "purchaseorder"t
Tim Pilgrim
10/12/2020, 10:45 PMyeah they are pseudo fields .... only available on when you search a po. its not really a field on the po
m
mrob
10/12/2020, 10:45 PMYikes, thanks for the help. Do you know of any way to allow to re-invoicing quantities on POs (in our case when the PO is credited via the invoice)
t
Tim Pilgrim
10/12/2020, 10:46 PMI think im missing the problem your trying to solve. Are you crediting out an incorrect invoice and raising a new one?
m
mrob
10/12/2020, 10:46 PMpresumably yes
mrob
10/12/2020, 10:47 PMthe vendor has invoiced quantity 4 of 5 but then for some reason realizes they need to credit quantity 1 of 5 (maybe the work wasn't complete yet or something). The next time they invoice we hope to see the line item still have quantity 2 to be invoiced (so 5 - 4 invoiced + 1 credited). Currently we'd only see quantity 1 remaining (5-4)
mrob
10/12/2020, 10:47 PMapologies if that's not straightforward
t
Tim Pilgrim
10/12/2020, 10:52 PMthe process is raise po for items -> time passed items received/ work is done..... so you raise a item receipt for the item/goods against the original PO. Thats the control for what you describe above. Then you only bill whats on the Item receipt. Therefore no credits required.
m
mrob
10/12/2020, 10:53 PMWe don't actually use item receipts and are a middle-man so we take vendor invoices/credits and convert them to customer invoices/credits
mrob
10/12/2020, 10:53 PMeverything is a noninventoryitem
t
Tim Pilgrim
10/12/2020, 10:56 PMohh... I dont think you can do what you want in that way then.... you would have to raise a new bill and or PO but the qty billed would not reduce with a credit as the billed number has not changed.... that is by design and correct if you get discounts for paying early for example.
facepalm 1
m
mrob
10/12/2020, 10:58 PMThanks, we'll have to brainstorm some more to figure out how to get around this issue