AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • Consulting
  • Login
  • Register
Acumatica Forums

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

Forums
AUG Forums
Everything Else
Import Scenario Pur...
 
Notifications
Clear all

Questions Import Scenario Purchase Receipts

 
Everything Else
Last Post by Michael Triffon 3 years ago
18 Posts
5 Users
1 Likes
2,736 Views
RSS
CharlesCRF
Posts: 9
 CharlesCRF
Topic starter
July 29, 2020 2:18 pm
(@charlescrf)
Active Member
Joined: 3 years 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

17 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
August 4, 2020 12:15 am
(@roycelithgo)
Honorable Member
Joined: 4 years ago

Perhaps a screenshot of your import scenario might help.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Active Member
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: 4 years ago

Honorable Member
Posts: 557
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: 3 years ago

Active Member
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: 4 years ago

Honorable Member
Posts: 557
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: 3 years ago

Active Member
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: 4 years ago

Honorable Member
Posts: 557
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.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Active Member
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: 4 years ago

Honorable Member
Posts: 557
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: 3 years ago

Active Member
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: 21
 Noah
August 9, 2020 8:44 pm
(@nmri)
Eminent Member
Joined: 3 years 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: 21
 Noah
August 31, 2020 10:12 pm
(@nmri)
Eminent Member
Joined: 3 years 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
Admin
(@timrodman)
Joined: 8 years ago

Famed Member
Posts: 3096
October 6, 2020 11:20 pm
Reply toNoahNoah

@nmri Thanks so much for posting your solution.

Reply
Michael Triffon
 Michael Triffon
(@michaeltriffon)
Joined: 4 years ago

Eminent Member
Posts: 22
February 10, 2021 10:25 pm
Reply toNoahNoah

@nmri

I am desperate to get scenario working, my customer fubared his tenant.

I already imported all the POs and now need to import the receipts. Unfortunately the scenario will only work with non expiry lot goods. Even then, it does not import the lot number.

By the way, why is there an extra =-1?

Here is the scenario, the only thing I added was expiry because we are using lots.

 

image
Reply
Michael Triffon
Posts: 22
 Michael Triffon
February 11, 2021 2:05 pm
(@michaeltriffon)
Eminent Member
Joined: 4 years ago

@timrodman Hi, my post is awaiting moderation, probably because I never uploaded an avatar. Now that it's done can you approve my post please? I have a customer in the middle of go live and I'm hoping someone can help me out.

 

Thanks, the site is amazing!

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 8 years ago

Famed Member
Posts: 3096
February 11, 2021 4:27 pm
Reply toMichael TriffonMichael Triffon

@michaelpabian Sorry for the delay. You should be good to go now.

Reply
Michael Triffon
 Michael Triffon
(@michaeltriffon)
Joined: 4 years ago

Eminent Member
Posts: 22
February 11, 2021 5:07 pm
Reply toTim RodmanTim Rodman
Michael Triffon

@timrodman Thanks!

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,388 Topics
  • 10.4 K Posts
  • 6 Online
  • 2,019 Members
Our newest member: Dulanjana Senevirathne
Latest Post: PDM vault conisio link
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

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×