In v5.6, the Serial/Lot reconciliation screen does not allow user to import serial nos or lot nos.
It should have an import function to make the process of entering opening balances of lots or serial nos easier and efficient.
by: Augustine T. | over a year ago | Operations Management
Comments
You should also be able to import them into the PO Receipts Serial/Lot screen. Most of our customers who have large stock volumes receive a electronic file from their supplier which details the serial numbers with this shipment.
For bringing in opening balances we had to write some SQL scripts to bring in the opening serial numbers. As if you are currently using IC and want to SN/LT it's virtually impossible without writing off all of your stock and then readding it all to let you put the serial / lot numbers into the system.
This is still a requirement in v6.o. Our customer has the correct I/C quantities posted and needs to add a large volume of serial numbers after the receipt is complete.
Sage has developed an SN import macro and a corresponding import template in CSV and Excel formats for IC SN Reconciliation. Contact tech support to obtain it. Hopefully it will be included in a feature product update for Accpac IC versions 5.6/6.0
Sage has psted the macro under knowledge base article 1000501
Jennifer, I could not finde the article 1000501 in Sage knoledge base. Can you doule check the number
This request is still applicable for Sage 300 2014.
Called Sage this week about it. There are no macros available in North America for this. They advised to talk to your Sage partner who can develop something for us.