Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
July 2022 - last edited July 2022
July 2022 - last edited July 2022
are you able to import data so they create orders rather than invoices??
trying to get around being able to import sales data, but them rejecting because we don't have enough stock entered into the system
if we could raise as orders than convert, this would address the issue.
Any otpions, I cant find any easily??
Solved! Go to Solution.
July 2022
July 2022
Hi @AmandaRobertsC , yes, sales can be imported as orders. For example, if you are using the Import/Export facility, set "Sale status" to "O" instead of "I".
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
July 2022
July 2022
@Mike_James I think you have just made my year!!!!
July 2022
July 2022
Thanks @AmandaRobertsC ! We have created a solution for a client who receives daily sales orders as CSV/Excel files from multiple sources, and we import them (ie post via the API) to their AccountRight file as invoices, but we check the onhand stock for every line, and if any line on the order has insufficient stock, we change the sale tatus to a sales order before posting it. This makes the import process more efficient.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
July 2022
July 2022
@Mike_James I now seem to be having trouble with getting the unit price to import.
it enters the orders as orders, and has the quantity correct, but the unit price comes through as zero, as well as the total line. The freight comes through correctly and the amount paid, but I can't ascertain why the price isn't loading correctly??
I even exported 1 order, again to copy all the headings and then did an auto match to re import, but it made me change one of the columns that the auto match did for Total Inc GST.
has this happened to your client?
July 2022
July 2022
Hi @AmandaRobertsC , the most common causes for nil amounts appearing in the imported transactions are commas or dollar signs in the amounts (for files prepared in Excel then saved as text, amounts should be formatted as General first), and possibly the sequence of columns in the text file.
If you wish, attach a copy of the file you are importing, or part of it, and the import log. Be aware that this is a public forum.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
July 2022
July 2022
Thanks @Mike_James
appreciate your help.
$ were defintely formatted as General
But still happened again.
Attached is a copy of the MYOB Order so you can see what is coming through and what is not
and the import file.
I;ve kept it simple to one transaction so its easy to trouble shoot.
July 2022 - last edited July 2022
July 2022 - last edited July 2022
Hi @AmandaRobertsC , it looks like you are importing a file designed for the current AccountRight program, in which case you'll need to add "{}" all on it's own (without the quotation marks of course) on the first line, so the column headings will start in row 2. Without those symbols, AccountRight treats the import file as being designed for v19, which has a different field layout.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
July 2022
July 2022
FINALLY GOT IT TO WORK!!
so thank you.
not easy, but hopefully worth the effort to import a lot of web orders.
I am very grateful.
Thanks
July 2022
July 2022
Great ! Glad it has worked for you.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
by
BareBeauty
4 weeks ago
8
221
|
8
|
221
|
||
by
Legends1
a month ago
0
125
|
0
|
125
|
||
0
|
100
|
|||
8
|
564
|
|||
9
|
554
|