Problems with importing Sales -> Item Sales

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Valued Cover User AndrewStephen
811 Posts
Valued Cover User
Australia
Valued Cover User

811Posts

563Kudos

14Solutions

Problems with importing Sales -> Item Sales

Evening

I am looking for some help with importing Item Sales with v2018.4.1 having just upgraded from v19.15

I managed to import 100+ records OK no errors accept the one record attached.

I am getting the following error 

Error -232: No location specified; default location cannot be substituted due to insufficient quantity.

The record being imported is set to an order, so insufficient qty should be an issue.
If I try to import the line from the file but itself it imports  OK without any issues.


This is the item that fails in the file I am importing, but as mentioned it import OK by its self.
11.005.0202,6,"Insert Banana Plug Red to Binding Post (Black)"

Really need some assistance with this one as I cant process any online sales (magento) since upgrade to v2018

Thanks
Andrew

3 REPLIES 3
MYOB Product Team Haydes
6,211 Posts
MYOB Product Team
Australia
MYOB Product Team

6,211Posts

1,033Kudos

889Solutions

Re: Problems with importing Sales -> Item Sales

Hi @AndrewStephen

 

The software can having problems importing in "large quantities" (100+ records is considered large in this context), and it can vary.

 

If it imports by itself just fine but has problems when grouped with the other records, could you try importing with a bunch of records? IE: Add that item with a group of 50 and see if this works?

 

Admittedly this is more of a fact finding mission rather than a direct solution.



Cheers,

Hayden (Ex-Moderator)
MYOB Product Team
Valued Cover User AndrewStephen
811 Posts
Valued Cover User
Australia
Valued Cover User

811Posts

563Kudos

14Solutions

Re: Problems with importing Sales -> Item Sales

Hi @Haydes

 

Actually its another bug in the software nothing to do with the size of the import file.

Doesn't make if there is one record or 1000+ records.

In the case of this error, each line by itself along with the 2 header lines {} and the field names import OK.
Its just when we try to import the entire record it give the error.

 

Its directly located to the location field in the import file which is something new added in v2018.4.1 I belive (stand to be corrected)

 

Didn't matter if the record was inported as an order, still got the error.


The import file contains an empy value for the location, but did match the field
ie
....  "Cheque Number",Category,"Location ID","Card ID","Record ID"

.... ,,,,G100028072,

Cheque is empty, Category is empty, Location ID is empty and Record ID is empty

 

This has worked in v19 (and earlier versions) since 2001 and works 99% of them time in v2018.4.1

 

 

 

 

Experienced Cover User Laura_HTS
15 Posts
Experienced Cover User
Australia
Experienced Cover User

15Posts

4Kudos

0Solutions

Re: Problems with importing Sales -> Item Sales

Did you end up with a fix for this?

 

We are using AR 2018.4 and are having the same import error, but am unsure how to fix it.

 

Thanks

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post