Small and medium business | Business Central, N...

Error when batch shipping Sales Order

(0) Share

Report

Posted on by JasonW

120

We have a Sales Order and associated paid Pre-Payment invoice, where we are shipping in batches. When we get to the final batch, we re-open the Sales Order, change the shipping date, then attempt to release. However, we can’t get past the following error:

Prepmt. Line Amount Excl. GST cannot be more than 57,272.72 in Sales Line Document Type='Order',Document No.='SO000189',Line No.='20000'.

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

MahGah 15,583 on at

Like (0)

Report
Copy link

Link copied!

Hi

What is the version of your BC? I just want to make sure it is not in the range of the following bug.

support.microsoft.com/.../-prepmt-line-amount-cannot-be-number-in-sales-line-document-type-order-document-no-documentnumber-line-no-linenumber-error-message-when-you-run-a-batch-for-the-order-in-microsoft-dynamics-nav-2136e936-53f6-1cf2-a2a2-76bce28e5147

Was this reply helpful? Yes No
JasonW 120 on at

Like (0)

Report
Copy link

Link copied!

BC is completely up to date. Version: AU Business Central 19.4 (Platform 19.0.35391.37474 + Application 19.4.35398.35925)

Was this reply helpful? Yes No
Suggested answer

Dallefeld 225 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Look at the total amount of the sales line and compare it to the prepayment amount on the sales line. There seems to be a difference which is causing your issue.

Was this reply helpful? Yes No
JasonW 120 on at

Like (0)

Report
Copy link

Link copied!

They are the same amount.

The issue here is we have done nothing other than follow the process for batch shipping. It should all work.

Was this reply helpful? Yes No
JasonW 120 on at

Like (0)

Report
Copy link

Link copied!

Does anyone have any other ideas?

Was this reply helpful? Yes No
Alfredo_Iorio 1,268 on at

Like (0)

Report
Copy link

Link copied!

Do you also change the posting date when you update the shipping date?

Also, is the order in a different currency other than LCY?

Was this reply helpful? Yes No
JasonW 120 on at

Like (0)

Report
Copy link

Link copied!

Yes, we change the posting date to reflect the date of the change, but the currency is all the same.

Was this reply helpful? Yes No
Alfredo_Iorio 1,268 on at

Like (0)

Report
Copy link

Link copied!

The fact that you get the error when you try to re-release the order after a prepayment invoice has been posted suggests the issue is between the sales line amount and the prepayment line.

I will check if the change of posting date triggers a sales price or discount update. Maybe you have special customer price or campaigns that kicks in and attempts to change the price on the sales line

If you have a prepayment % on the sales header and the price is updated you will get an error about the prepayment. The error message might be misleading depending on your localisation.

I get the same error if I reopen a sales order with a prepayment line applied.

Note that when I clear the error, the price returns to its original value of £30 therefore you might not see the price difference that is blocking your order.

Was this reply helpful? Yes No
JasonW 120 on at

Like (0)

Report
Copy link

Link copied!

Hi Alfredo

I very much appreciate your support on this and it's interesting you can reproduce the error. However, isn't the price difference in your screen shot due to one price excluding VAT and the other (in the page data) including VAT?

Was this reply helpful? Yes No
Alfredo_Iorio 1,268 on at

Like (0)

Report
Copy link

Link copied!

The VAT is not relevant to this error.

The error in the screenshot is because BC tries to update the line amount while there is a prepayment invoice already posted for the line.

The sales line has a posted prepayment invoice equivalent to 50% of the order.

The order will post fine so no errors here.

But if I get the error if I reopen the order and try to change the unit price or if I add a discount which might be your issue.

Was this reply helpful? Yes No