Error -274: The combination of Quantity, Unit Cost and Amounts values is invalid.

Domcar

Hi there

I have recently purchased a business that has been unit MYOB for 11yrs

We exported his myob file, created a new fresh file for my company and imported the data.

The issue was the 3900 inventory items came across with no qty on hand or dollar value forvalue on hand

After spending ages on the phone with support staff I was told I can not import these fields so I spent half the day manually entering the stock qty via the count stock window.

 

I have been having a play with importing and exporting inventory adjustments

It seems that I can import stock values via this method.

If I import them 1 at a time it works, but when I try and import multiple qtys I get this error

Error -274: The combination of Quantity, Unit Cost and Amounts values is invalid.

 

I have zero value for all of my stock items now and most of them have a positive qty on hand.

I have attached a sample of the txt file I am trying to import which gives me this error.

 

I would be so grateful if someone can let me know why I am getting this error so I can import the 3800 lines without having to do this manually line at a time.

 

The file INADJ.TXT imports fine with no errors

INADJ66.TXT gives the error as per the log

Thanks in advance

richard

INVADJ.TXT

INVADJ66.TXT

importlog.txt

Andrew_Y

Hello @Domcar 

 

Thanks for your post.

 

After testing with your examples I was able to replicate your error. 

 

AccountRight will flag this error when you are attempting to enter a journal adjustment with zero$ Amount Quantity and Unit cost.  By contrast if these fields have a non-zero amount it should allow this entry. 

 

The conflict is that it is an inventory adjustment that has no adjustment made.  While you can EXPORT these from AccountRight, it does not allow you to IMPORT these void entries.  You can test this by creating a zero adjustment and exporting that entry, and attempt to import it.

 

 

Removing these entries (see file attached) I was able to successfully import the data.  Note that you may need to have qty on hand first, or you will throw a different error.

 

If this has helped understand the issue better kindly consider marking this post as a solution to help others that may be looking for answers.

INVADJ66 (EDITED).TXT