Inventory Transfer In in SO -- How to import a list of items

Posted by Andrew on December 19, 2007, 11:28 am

Please log in for more thread options

Hi there,

May I ask how can I import a list of item with qty in SO?
I found that there is only a "add item" button and "Quick Scan" button,
which can only add items into the transfer in order one by one...

I already have a list of item on hand, how can I import it without importing
one by one? (I want to do it by Transfer in but not item quantities
adjustment because I need the "Transfer In" record)

I can do it at HQ inter-store transfer but cannot do it at SO transfer
in...please help!

Andrew

Posted by convoluted on December 19, 2007, 12:04 pm

Please log in for more thread options

Maybe you can import the items with zero quantities first using a tool like
QSC import.....then import your file using the physical inventory area in SO
manager - it allows for an import file where all you have are item lookup
code (or alias) and the qty as your importing columns - the physical
inventory will leave an audit trail in the system - make sure you are
tracking item movements in SO manager - file - configuration - options --
hope this helps

"Andrew" wrote:

> Hi there,

> May I ask how can I import a list of item with qty in SO?

> I found that there is only a "add item" button and "Quick Scan" button,

> which can only add items into the transfer in order one by one...

> I already have a list of item on hand, how can I import it without importing

> one by one? (I want to do it by Transfer in but not item quantities

> adjustment because I need the "Transfer In" record)

> I can do it at HQ inter-store transfer but cannot do it at SO transfer

> in...please help!

> Andrew