Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upgrade from Macola 7.8.900 to 7.9.300 - Post invoice problem

Status
Not open for further replies.

AndrewForrest

Programmer
Jan 27, 2004
43
0
0
AU
Hi,

We are in the process of upgrading to Macola 7.9.3 and moving to MS server 2016 & SQL 2016, at present we have just upgraded to 7.9.300 on MS 2012 & SQL 2012. we create a separate SQL box and installed Macola 7.8.900,created the companies brought the databases across and then upgraded to 7.9300. We are currently testing the upgrade - but i have a problem with "Post invoices"
I have tried on 2 different companies, created an Invoice, created a new order and tried invoicing a current order it all seems to work OK until I try to post the invoice, when i get :-
"Distributions are out of balance (or total sales amount is not Equal to Amount Distributed"
and posting fails, as far as i can see the figure look right.
we are an Australian Co with multi currency. (one Inv. had conversion rate of 1.00 the others had 0.6797)
I have reported to ECI but only passed it to tech support response so far.
Any ideas??


"Don't worry about the world coming to an end today.
ItÆs already tomorrow in Australia." - Charles Schulz
 
Created an OE invoice correct? If so was this from an existing type O order, a new type O order, a type I order or what?

Was this one order/invoice or all orders/invoices?

Then you "created a new order". What relevance does this have if you did not create an invoice from this new order?

So please clarify what you did/provide more details.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

 
Hi Don,

apologies.
I invoiced from an existing order type O (created prior to the upgrade).
select for billing - bill certain items
selected item to ship
entered Qty to ship, ticked selected and then selected the serial-lot
exited out
viewed Billing Info
printed invoice - printed correctly = Yes.
order status = 9
Printed Pre-Post invoice list - invoice on list

run post invoices
message
******************************************
**** Distributions Are Out Of Balance ****
**** (Or Total-Sales-Amount Is Not ****
**** Equal To Amounts Distributed) ****
******************************************

I created a new OE order type O and then select for billing and tried to invoice it as above same result.

I then went into Enter orders- create an invoice (order type 'I')
selected customer
enter item - ord Qty/ship Qty
selected Serial lot
escaped viewed Billing Info
selected to print invoice immediately
printed invoice correctly = Yes
order status = 9
Printed Pre-Post invoice list - invoice on list

run post invoices
message
******************************************
**** Distributions Are Out Of Balance ****
**** (Or Total-Sales-Amount Is Not ****
**** Equal To Amounts Distributed) ****
******************************************




"Don't worry about the world coming to an end today.
ItÆs already tomorrow in Australia." - Charles Schulz
 
What does the yellow highlight mean?

Code:
I then went into Enter orders- create an invoice (order type 'I')
selected customer
enter item - ord Qty/ship Qty
selected Serial lot
escaped viewed Billing Info
selected to print invoice immediately
printed invoice correctly = Yes
order status = 9
Printed Pre-Post invoice list - [highlight #FCE94F]invoice on list[/highlight]

Did the pre-post invoice list show errors on this order? Or just the first 2 orders? Or just the 1st order?

Did you take the original order back to status 8, or is it still status 9? When you try to post, you will ALWAYS - as in forever - get "distributions out balance" error unless you a) only tried to post your 2nd or 3rd invoice by themselves and not all invoices or b) took the original errors back to status 8.



Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

 
No I had not taken the orders back to status 8 - good catch,.
I have now taken all the orders back to status 8, i have tried printing and posting the orders 1 at a time - taking each back to status 8 after it failed.

"Invoice on List" means when i ran the pre post report the invoices where on the list (all of them) - no errors reported in that report.

I have now moved all the invoices back to status 8.

I have now created a new order type 'O'
then selected for billing
enter item - ship Qty
ticked "Selected"
selected Serial lot
escaped viewed Billing Info
Opened Print invoice for new order only
printed invoice correctly = Yes
order status = 9
Printed Pre-Post invoice list order/invoice is listed with no error see attached image
tried to posted invoice
same error. - second attachment.

prepost_vmzsfy.jpg


InvPost_fkvno8.jpg


"Don't worry about the world coming to an end today.
ItÆs already tomorrow in Australia." - Charles Schulz
 
Hi Don,

No, no resolution yet - ECi are looking at it but no joy, the latest hot topic has been installed, my understanding is that we are not the only ones with this bug/problem, it may be to do with older item records.

Happy Safe & Prosperous New Year to you and yours.
Andrew.

"Don't worry about the world coming to an end today.
ItÆs already tomorrow in Australia." - Charles Schulz
 
Hi Don,

Sorry did not see your post of the 4th, I was on factory shutdown.
I have received a response fro ECi with a hot fix "Prog79300UHT.zip" this seems to have fixed the problem, back to testing....

The problem (was also in Macola ES), occurs when you have the same item and lot number assigned to multiple sales orders, but you are posting only the higher order number order.

For example:
Order 1 is for Lot A and has been selected for billing (or confirm shipped) so that Lot A has been allocated to this order.

Order 2 is for Lot A and has been selected for billing so that Lot A is also allocated to the order.

Now you print the invoice for Order 2 and try to post it. When you do the system is including the distributions for order 1 even though it has not had the invoice printed and is not being posted. For this reason the distributions are out of balance.

I got lucky with my testing this time we could have been working for weeks before hitting this problem.


Thanks for assistance.

Regards
Andrew.


"Don't worry about the world coming to an end today.
We're already in tomorrow in Australia."
 
Wow that is incredible. This is something that might only happen once or twice a year for crying out loud. Contact me anyway if you don't mind.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

 
Andrew I have 2 Andrew Forrests in my LinkedIn connections, one in Australia and 1 in the UK. Which one are you?

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top