Can I upload inventory values from excel to gp?

(0) Share

Report

Posted on by Community Member

We are about to use gp for our first full inventory and I was wondering if there was an easy way to get the counts and lot numbers from excel to gp besides using the stock count function? Our inventory in gp has never been that good so I am not too worried about wiping it all clean and starting fresh because we have put things in place to help going into the future? Any suggestions would be appreciated! Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

You could upload it as a variance transaction - emphasis on the word variance. This means you will have to get the current stock from GP (easily done with SmartList) and substract from your count. Your import will be for the difference to arrive at the count. You can use Integration Manager or any other product you have at your disposal to create the import.

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report
Copy link

Link copied!

I'd second Mariano's suggestion; make sure you have the transaction type set to Variance rather than the default of Adjustment.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Is this something that is fairly easy to do for someone who is fairly new to the software?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

If you own the Integration Manager it should be pretty straightforward. You will probably need assistance setting it up the first time just so you can see how it works.

Kind regards,

Leslie

Was this reply helpful? Yes No