AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Import Scenario Pur...
 
Notifications
Clear all

Import Scenario Purchase Receipts  

    Last Post
RSS

CharlesCRF
Posts: 9
 CharlesCRF
July 29, 2020 2:18 pm
(@charlescrf)
6-20 Posts
Joined: 6 months ago

Hello All,

I'm trying to import purchase receipts and a post from this forum has given me a great start.

https://www.augforums.com/forums/acumatica-import-scenarios/import-scenario-for-purchase-receipt-with-serialized-stock/

The link is for serialized inventory which doesn't apply to us.  I've added quantity and description instead.

While trying to import by scenario I'm getting the following error message

"Error: The string value provided exceeds the field 'Type' length."

I've checked multiple times, I have it like it should be ='Receipt' and I don't have the column in my data provider.

Anybody have any ideas?  Any help would be greatly appreciated.  Thank you.

Charles

13 Replies
Royce Lithgo
Posts: 445
 Royce Lithgo
August 4, 2020 12:15 am
(@roycelithgo)
Over 200 Posts
Joined: 10 months ago

Perhaps a screenshot of your import scenario might help.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 6 months ago

6-20 Posts
Posts: 9
August 4, 2020 11:45 am
Reply toRoyce LithgoRoyce Lithgo

@roycelithgo Right!  Sorry about that.  Screenshots are below.

image

 

image
Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 10 months ago

Over 200 Posts
Posts: 445
August 4, 2020 9:21 pm
Reply toCharlesCRFCharlesCRF
Royce Lithgo

@charlescrf Is it possible it's the OrderType that has an issue? What values do you have in 'PO Type'? I would check all field values from the input file and make sure they are valid.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 6 months ago

6-20 Posts
Posts: 9
August 5, 2020 10:03 am
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo

@roycelithgo Thank you for your help on this.  I have column header as "PO Type", and the value as "Normal" in my excel file for data provider.  My excel files doesn't have quotation marks but should I have this entered as something else?

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 10 months ago

Over 200 Posts
Posts: 445
August 6, 2020 1:00 am
Reply toCharlesCRFCharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@charlescrf I just noticed a bug in your import scenario:

The field should be OrderNbr not OrderType.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 6 months ago

6-20 Posts
Posts: 9
August 6, 2020 12:30 pm
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@roycelithgo Good eye!  I can't believe I've overlooked such a simple thing.  I've changed "Add Purchase Order" to "Add Purchase Order Line" as well. If you look at provided example in the link from my original post, that's the way it should be.

I've now gotten past that error message!  Thanks!

The new error message is that it can't find the order number in the system.

image

I've censored some sensitive information.  I'm surprised it can't find the order number because I've already imported a purchase order with that exact order number.

image

What am I missing?

 

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 10 months ago

Over 200 Posts
Posts: 445
August 6, 2020 1:32 pm
Reply toCharlesCRFCharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo
Royce Lithgo

@charlescrf That's really strange - the key for the PO is Order Type and Order Nbr and they look correct in your data. I can only suggest trying the data entry yourself. In other words, go to the PO Receipt page and add the Receipt manually assigning the fields in the same order as they are in your Import Scenario. Hopefully you should hit the same error and that might identify the issue.

This post was modified 6 months ago 3 times by Royce Lithgo
Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 6 months ago

6-20 Posts
Posts: 9
August 10, 2020 10:52 am
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@roycelithgo Excellent advice!  I guess the problem was with the status of the PO.  It's "Pending Printing".  The system found the order number after I've printed the PO and the status changed to "Open".  I have over a thousand PO's that I've imported and almost all have a status of "Pending Printing" or "On Hold".  Is there a way I can change the status of all the PO's to "Open" without having to go into them manually and changing them one by one?

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 10 months ago

Over 200 Posts
Posts: 445
August 10, 2020 5:29 pm
Reply toCharlesCRFCharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo
Royce Lithgo

@charlescrf You'd need to create an Import Scenario to do it. Write a GI to export all the POs you want to update and then write an Import Scenario to do the updates. 

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 6 months ago

6-20 Posts
Posts: 9
August 10, 2020 6:48 pm
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@roycelithgo I haven't worked with general inquiries before.  I'll have to give it a try!  Appreciate all the help!

Reply
Noah
Posts: 16
 Noah
August 9, 2020 8:44 pm
(@nmri)
6-20 Posts
Joined: 6 months ago

I'm having the same issue. Manually entering the PO number works fine, but I get that same error message as CharlesCRF...it can't find the Order Nbr.

 

If anyone has found a solution it would be greatly appreciated!

 

BTW, just found the forum and am so grateful for the all the knowledge and help so far!!

Reply
Noah
Posts: 16
 Noah
August 31, 2020 10:12 pm
(@nmri)
6-20 Posts
Joined: 6 months ago

I know the CharlesCRF ended up having a different goal than I did, but I wanted to post the solution I found to adding serial or multiple lot numbers to a Purchase Receipt in case anyone else stumbles upon this thread.  My partner actually warned me that this was a very difficult Import Scenario to accomplish.

 

Here is the screenshot of it (my data provider column key's are slightly different to what they are mapped to, but I think it's pretty obvious):

 

PO Receipt Serial

 

The one that is cut off is <Action:Add PO Line>(AddPOOrderLine)

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2488
October 6, 2020 11:20 pm
Reply toNoahNoah

@nmri Thanks so much for posting your solution.

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,656 Topics
7,693 Posts
4 Online
1,110 Members

Latest Post: Timecard reports/queries Our newest member: Janetteraab Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×