Importing product data into an open invoice, using excel spreadsheet

Question

Hi MYOB community,I am trying to figure out how i can open a new customer invoice, and then once the invoice is open, import product/sales data into the new invoice using an excel spreadsheet file. The excel file would only contain the following three data columns - 'Ship (qty)' / 'Item Number' / 'Price'.I would think this should be a simple action, if MYOB was moderately ai advanced?&nbsp;Please see screenshot below of example excel spreadsheet data. Any feedback or advice would be greatly appreciated. Thank you, KateWoo :)&nbsp;&nbsp;

isaiah_c · Answer

Hi KateWoo,
&nbsp;
Importing data directly into an open invoice from an Excel spreadsheet is not a built-in feature in MYOB. However, we do have the In Tray feature, which allows you to upload and manage documents like bills or receipts and match them with transactions in your MYOB system.
&nbsp;
Regards,
Sai
&nbsp;

katewoo · Answer

Thank you for your reply. That is not the function i am trying achieve. I see there are some 3rd party apps such as Transpost or BusinessImporter that can be purchased to do this (but don't want to pay for another subscription) - its just shame that MYOB does offer a feature like this, it really should be more ai savvy with these kind of import features. Thank you.

isaiah_c · Answer

Hi KateWoo,
&nbsp;
Thank you for sharing your feedback! We appreciate your input, and I hope this feature will be considered and added to MYOB soon. Your suggestions help us improve, so thank you for taking the time to let us know.
Regards,
Sai
&nbsp;

Forum Discussion

Importing product data into an open invoice, using excel spreadsheet

Looking for something else?

Related content

Importing Invoices

Importing invoices - urgent

Importing sales Invoices

Importing issue

Inventory - cubes on packing slip and MYOB 'talking' with spreadsheets

Importing failing

Importing Sales Orders rather than Invoices

Importing from Excel Spreadsheet