Hello,
I am trying to create a GI that shows Vendor ID, Vendor Name, and Lead Time so I can revise it and upload back to Acumatica using a Data Provider/Import Scenario. I cannot find the field for vendor lead time in the GI builder. Anybody know which table to add?
Best answer by ejmillar
View original
Vendor Leadtime is in VendorAttribute.Location DAC.
I still cannot seem to find this in the GI builder. The VendorAttribute + Contact only shows the Vendor Contact fields. There is no VendorAttribute.Location.
I created a GI and found the Vendor Lead time in the following dac:
PX.Objects.CR.Location.
The field is called vLeadTime.
How do I tie this to the vendor? I don’t see any vendor ID or description fields in that table.
On bAccountID as below.
Thank you!
Hey
If this helps at all, I recently built a GI that looks at the PO date and the purchase receipt line date and gives you some numbers on days of lead time
With a pivot table, you can summarize the Min/Max/Avg days of lead time per vendor and then use that to adjust the value on the vendor’s purchase settings
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
