MYOB Upload issue

Question

We are trying to Upload txt files for ITEM creation and the Purchase order creation. One item, we are successfully able to upload but when we go and upload the Purchase file, It fives an Error -192: Duplicate Supplier Invoice Number. We have checked manually the supplier invoice number does not exist on any of the past POs. Can you please check what is the real issue?

File Attached

1. MYOB error log

2. Item Import file (Successfull)

3. Purchase import File (Un-successfull)

04_02_2022 165927_OUTPUT_PURCHASE_ITEM_Alteryx.txt

04_02_2022 165928_OUTPUT_ITEM_Alteryx.txt

importlog 20220204 - R3GB84.txt

Komal_S · Answer

Hi @Yashdeep

Apologies for the delay in response.

If you're still experiencing this problem, can you just try importing one purchase line, delete the number from the import file and re-enter it, and let us know if the problem exists? Before doing so, please also untick the preference for warning for duplicates under Setup>>Preferences>>Purchases to rule out any interference caused by this setting.

Yashdeep · Answer

@The_Doc Thanks for the reply, appreciate that.

The files are tab delimited already. I've been uploading POs and items from last two months with commas and never had an issue. There are times when you can't avoid it.

Just to be double sure, I uploaded both (ITEM and Purchase) files in my MYOB clearwater test environment and it happened without any issue.

I'll wait for more detailed explanations.

The_Doc · Answer

Hi @Yashdeep

Any "," in an import like that will throw an import wildly - and will give you odd errors.

Convert to tab delineated imports and get rid of commas in addresses - they are a huge headache and in item descriptions - people use them without thought.

You can import with commas included but you have to enclose everything in open and closed speech marks and I just find that an even bigger problem.

The Doc