Import/Export: Item Sales - Import quantities and item numbers - prices comes from price matrix
Hello,
I'm wondering if I can only import the items and quantities, and then MYOB applies the default pricing matrix which is already in system.Eg, import csv file as follows-
1. Import Date Customer Name/cardid, Item Number and Quantity.
2. MYOB generates invoice using imported data and pricing rules in MYOB
I was able to successfully do step1, however the sales order generated all had $0 for price. I thought we could have some sort of an option or setting on items wherein MYOB could override or apply pricing if not present in the import data.
We have 2000 + sales orders generated every month and complex pricing rules depending on the customer and the quantity. It was great to set up the pricing rules in MYOB but I can't indivudally generate the invoice for every customer each month as the item quantity will vary each month. MYOB being such a mature accounting software, I thought this would be already present.
Can this be made available? IF not is there a workaround to this?
~David.
"Importing Item Sales without Price and applying Price from MYOB"