Skip to main content
Answer

Vendor Lead Time GI

  • May 9, 2024
  • 7 replies
  • 167 views

Forum|alt.badge.img

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

On bAccountID as below.

 

 

 

7 replies

ejmillar
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • May 9, 2024

Vendor Leadtime is in VendorAttribute.Location DAC.

 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 9, 2024

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.

 

 


ejmillar
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • May 9, 2024

I created a GI and found the Vendor Lead time in the following dac: 

PX.Objects.CR.Location.

The field is called vLeadTime.


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 9, 2024

How do I tie this to the vendor?  I don’t see any vendor ID or description fields in that table.


ejmillar
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • Answer
  • May 9, 2024

On bAccountID as below.

 

 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 9, 2024

Thank you!


Forum|alt.badge.img+2
  • Captain II
  • May 9, 2024

Hey @josborn - 

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