By using this website, you agree to our Terms of Use (click here)
Hi,
For screen id: SO303000
We just upgraded to 2018 R1. We are utilizing the new alternate ID & UOM support added in 2017 R2. We need the invoice report to state the alternate id. I know it is located within SOShipline, I just dont know how to make the join and with what parent. I tried ARtran with no luck. Any help would be greatly appreciated.
Also on the invoice report, what are other doing to display the payment method used (we accept checks in addition to credit cards)? For Credit Card orders i've added the PMinstanceid description field.
Thank you,
Richard
For your first question:
ARTRan Left (you could use inner) SOShipLine
SOShipmentNbr Equal ShipmentNbr (Now we're looking at the right shipment)
SOShipmentLineNbr Equal LineNbr (Now we're looking at the right line in the shipment)
InventoryID Equal InventoryID (this line is redundant, but it makes me feel better knowing the inventory ID's must match)
As for your second question: I don't report that field, but shouldn't ARInvoice.PaymentMethodID work for this?
I suppose I should add, in case you're not using it, that CRTL+ALT+LeftMouse will show you the name of a field in a screen. For your 2nd question, I opened an invoice, went to the Financial Details page and then used CRTL+ALT+LeftMouse to find the field name: ARInvoice.PaymentMethodID.
Thank you, that did the trick.
For Paymentmethodid, I used this originally. the only problem is if the customer is on net 30 terms. They might get confused about it saying their payment method. What I ended up doing was adding the Arinvoice.status and ARinvoice.curydocbal.