Inventory Export Price fields skipped
I have created a new data file for our use & exported Cust, Supp, Employees, & Inventory. Some of the sell prices (ABCDEF) in some of the items are missing. It is not every item or the same price l...
Forum Discussion
Thanks
The problem seems to begin at the point of export.
ST-108-700sht,52,0,49,0,49,0 - from the exported text file.
Prices are correct in MYOB
It appears that there is another delimiter forcing the skipping of the next price field, forcing the B price into the C field, & the C price into the E field.
Hi Graeme59 , did you export all fields? If so, try another export, but select only the fields required to update the selling prices - item code, item name, sell price, Quantity Break 1, price levels A-F qty break 1. Open the file in Excel to see if the alignment is correct.
When importing this file, do not match the item name, because you do not need to update it.
Would you be able to attach an extract of the faulty txt file with two lines - column headings and 2-3 faulty lines?
Graeme59 , research on the forum led me to another explanation, that "A common cause for 'wrong' selling prices being exported is due to duplicate entries in the price matrix. These are not visible to the user. Basically sometimes when importing a price update, rather than updating, MYOB creates a new entry. When you view selling prices on screen, MYOB retrieves one of the prices. When you export, it retrieves a different one."
See Export doesn't work properly | MYOB Community
You can run a price detail report to the screen and review it ,where you may find some products with 2 columns of prices, both labelled quantity break 0
The solution is for MYOB to run a script on the file to fix these errors.
Thanks James
I have run a price detail report & got a very funny result.
MYOB shows 2 columns for Quantity Over 0 on the report, but on shows 1 column in the APP.
With different pricesI then reset column 2 to Quantity over 999 items and set the prices in that column to 0.
This is the report.
I still have 2 Zero Columns. Is this a bug in MYOB ?Hi Graeme59 , yes that is the bug I mentioned which will cause errors in your item prices export. MYOB need to run a script over your file. Contact support for help as moderators/MYOB staff are no longer able to run it.
