Skip to main content
Answer

Bills and Adjustments Import Scenario

  • December 13, 2022
  • 11 replies
  • 782 views
O
Freshman I
Forum|alt.badge.img

I’m trying to import some data into bills and adjustments and its giving me the error “SuppliedbyVendorID cannot be empty” I’ve never had this before - can someone let me know what I need to look at to mitigate the issue? 

Best answer by Manikanta Dhulipudi

hI @ocarvalho 

Please find the Import scenario. In My testing I only updated the qty, feel free to add the required columns.

Thanks

 

thomasdavid

11 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @ocarvalho 

Could you please share Import scenario and Mapping sheet ?

 

Are you creating Bill and adjustment directly or Link any receipt?

Basically it is missing vendor details in Bills and Adj>Financial tab> receipt info

Thanks

Acumatica Functional Consultant & Customer Experience Supervisor
aborisova37
Chris Hackett
O
Freshman I
Forum|alt.badge.img
  • ocarvalho
  • Author
  • Freshman I
  • December 13, 2022

@manikantad18 here you go! thank you

 

We do not have receipt info in our financial tab

1 Attachments
thomasdavid
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

@manikantad18 here you go! thank you

 

We do not have receipt info in our financial tab

Could you please share me your Import scenario which is designed

Acumatica Functional Consultant & Customer Experience Supervisor
O
Freshman I
Forum|alt.badge.img
  • ocarvalho
  • Author
  • Freshman I
  • December 13, 2022

@manikantad18 here you are

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

@manikantad18 here you are

Sorry to ask, share me directly XML report. it will users time to assist you 

Acumatica Functional Consultant & Customer Experience Supervisor
O
Freshman I
Forum|alt.badge.img
  • ocarvalho
  • Author
  • Freshman I
  • December 13, 2022

@manikantad18 sorry here you are 

1 Attachments
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Thanks for sharing, At first glance you have not defined the vendor details while creating bill, Please map vendor and do the Import

Acumatica Functional Consultant & Customer Experience Supervisor
O
Freshman I
Forum|alt.badge.img
  • ocarvalho
  • Author
  • Freshman I
  • December 13, 2022

Thanks for sharing, At first glance you have not defined the vendor details while creating bill, Please map vendor and do the Import

@manikantad18 the bill is already created, we’re just updating the bill with vendor cost 

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

hI @ocarvalho 

Please find the Import scenario. In My testing I only updated the qty, feel free to add the required columns.

Thanks

 

1 Attachments
Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
O
Freshman I
Forum|alt.badge.img
  • ocarvalho
  • Author
  • Freshman I
  • December 13, 2022

@manikantad18 Thank you!!! We fixed it but now this error is popping up - how can we have it import even though its used

 

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hello @ocarvalho 

Same vendor Reference has been used in another Bills document, Please give another number and proceed.

Thanks

Acumatica Functional Consultant & Customer Experience Supervisor
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved