Distribution, Manufacturing, and Internet Modules

[mitchelleabrams]

Does anyone know the cause of a Purchase Order to print at the bottom, ***ORDER OUT OF BALANCE***?

We continuously have this problem.  It always seems to happen when we modify the purchase order, but can't put our finger on the root cause.  Is there a way to change it so the order is not out of balance?  It always prints with the total as 0.

Thanks!

[BigLouie]

Welcome to the Sage Community. When a Purchase Order form  prints out ***ORDER OUT OF BALANCE*** it is beause the line totals do not match the totals on the header.  The totals at the bottom of Tab 3 should equal the total on Tab 4.

[BShockley]

Try changing the tax schedule on the p/o header screen to another tax schedule, and then change it back to the desired tax schedule.

[mitchelleabrams]

Thanks all.

[SPyle]

You should consider rebuilding your key files, line files, and sort files for PO.  Also, you should find out if it is one person that is constantly creating these POs or if everyone is having an issue with the out of balance.

If "all the time" means daily, if you have only one person with this problem, it may be a network connection- You could have IT switch the cable to another port and see if that resolves the issue.

[ajudson]

Hello all,

I am currently experiencing a similar problem.  The issue with the printed purchase order form reading ***ORDER OUT OF BALANCE*** just started to occur yesterday afternoon (we've never had this issue before). 

None of the information on the form is filled in when attempting to print the form, except for the ***ORDER OUT OF BALANCE*** at the bottom of the page and a *TAX ERROR* in the "Sales Tax" field.  What's confusing is that previous POs entered yesterday did not have this issue; only the latest three PO numbers created, which were 10,000 and above (all of which are the only ones having this printing issue).

From the previously proposed resolutions, I've confirmed that the totals on tabs 3 and 4 are identical and even tried adjusting the tax code as the other user suggested, none of which seem to have any effect.  

I created a testing company using the information from our primary company to try and isolate the problem, but the error is not replicated in the testing company.

Any additional ideas on how to correct this problem would be greatly appreciated.

[VKZIMM]

Are you using the same form in both companies?

Maybe you have an extra file linked in one for example with UDF's and they are not matching and bringing in the PO lines since you said the form is blank.

Does it happen with a default form?

[ajudson]

VKZIMM,

When creating the test company, I made sure to copy all forms from the parent company.  That being said, all the same forms exist within each company's reports folders. However, when viewing them in Crystal through the "Crystal Purchase Order Printing" window (which is the pop-up after selecting "Quick Print..." from the "Purchase Order Entry" window), they don't appear to be 100% identical - specifically, the "Details b" field.  Why that is, I am not sure.

We have three form codes in both the testing and production companies.  In the test company, they all work fine.  In the production company, all three forms create the same blank report with the "out of order" text previously mentioned.

[VKZIMM]

Within crystal,  Click on Database, database expert and see if they are using the same files.

You can also check the linkages.

[SPyle]

What version and release are you on?