Skip to main content
Solved

Bills and Adjustments Import Scenario


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

 

View original
Did this topic help you find an answer to your question?

11 replies

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

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • December 13, 2022

@manikantad18 here you go! thank you

 

We do not have receipt info in our financial tab


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
ocarvalho wrote:

@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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • December 13, 2022

@manikantad18 here you are


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
ocarvalho wrote:

@manikantad18 here you are

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • December 13, 2022

@manikantad18 sorry here you are 


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

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • December 13, 2022
manikantad18 wrote:

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+13

hI @ocarvalho 

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

Thanks

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • 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+13

Hello @ocarvalho 

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

Thanks


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings