Unbalance GL

[jjz]

Hi , is anybody know why the following unbalanced GL happend ?

glt_det Detail generated by invoice post in MFG/PRO 8.5e:

Exch Rate Amount Eff Date Account Document T
------------ ------------------ -------- -------------- -------- --
1.45000 -5,955.00 09/09/02 2160-2000-3000 IC171969 I
1.45000 4,421.90 09/09/02 2160-2000-3000 IC171969 I
1.45000 -947.10 09/09/02 2160-2000-3000 IC171969 I
1.45000 652.52 09/09/02 2160-2000-3000 IC171969 I
1.45000 -8,468.00 09/09/02 2160-2000-3000 IC171969 I
1.45000 5,752.14 09/09/02 2160-2000-3000 IC171969 I
1.45000 -2,540.40 09/09/02 2160-2000-3000 IC171969 I
1.45000 1,725.65 09/09/02 2160-2000-3000 IC171969 I
1.45000 -12,255.36 09/09/02 2160-2000-3000 IC171969 I
1.45000 9,132.05 09/09/02 2160-2000-3000 IC171969 I
1.45000 8,481.62 09/09/02 1150-2000-1050 IC171969 I

Amount Total = 0.02 , and flagged as unbalanced .
Is it caused by round-up method (all of currencies use system default '2') ? How to prevent it from happening again ?

Thanks a lot.

 

[Ricardo Rafols]

round

Jjz,

the problem can ocurred if your taxes have more 2 round method or any price that have .9999999 .

Ricardo Rafols

 

[Ricardo Rafols]

glt_det unbalance

Hi again,

u can see the 2.13.1.17 (round method) and the 2.13.24 (Taxes File Control to see whose are the actual method used by the GTM.

Ricardo Rafols

 

[jjz]

Thanks a lot , but we aren't using Global Tax Management module
, instead , simple VAT setting :

vtpm.p f+ 2.15.2.24 VAT Control File 30/09/02
+------------------------------------------------------------------------------+
| Default Tax Class: V |
| Discount VAT at Invoice: yes |
| Discount VAT at payment: no |
+------------------------------------------------------------------------------+

ctcliq.p f 2.15.2.2 VAT Class Inquiry 30/09/02
+-----------------------------------------------------------------------------+
| GST Class: v Effective: / / Output: terminal|
+-----------------------------------------------------------------------------+
+------------------------------------------------------------------------------+
| GST Class Start Eff End Eff GST Pct AP GST Acct AR GST Acct |
| --------- --------- -------- -------- ----------- ----------- |
| V 25/06/98 31/12/49 17.50% 12300340 1100 12300345 1100 |

mgrndiq.p 99 36.3.10 Rounding Method Inquiry 30/09/02
+------------------------------------------------------------------------------+
| Rnd |
| Mthd Output |
| terminal |
+------------------------------------------------------------------------------+
+------------------------------------------------------+
|Rnd Dec|
|Mthd Description Rnd Unit Threshold Pt.|
|---- ------------------------ --------- ---------- ---|
|0 Round to Ones 1.000 0.5000 . |
|1 Round to Tenths 0.100 0.0500 . |
|2 Round to hundredths 0.010 0.0050 . |

Most of the other invoices were posted well and all of sales orders
/invoices related to the unbalanced GL were input mannually by normal users , so up to 5 digit after point is allowed for sales price.

Any help is great appreciated.
Best Regards.
Jjz.

 

[prog_user]

Unbalanced GL

Hi Ricardo -
Once again i would like to point out that even we are facing some unbalance issues in the GL while trying to post Transactions.
This happens only sometimes (most of the times it goes smoothly)

We have noticed that we have this issue only for a particular German Customer. Im not sure how to debug this problem and we were hoping that it was a QAD patch issue and were hoping to have it resolved while installing Service Pack 4.0 (MFG/PRO 9.0)

However if it is an issue in how our Price Lists have been setup, then i would be interested in knowing how to get rid of this problem.

We are using GTM and have the Rounding Method setup as :

Rounding Dec
Method Description Rnd Unit Threshold Pt.
-------- ------------------------ --------- ---------- ---
0 Round to Ones 1.000 0.5000 .
1 Round to Tenths 0.100 0.0500 .
2 Round to hundredths 0.010 0.0050 .


And the GTM Control File set up as :

Tax Zone: ERROR-ZONE
Tax Environment: ERROR-ENVIRONMEN
Country Code: US
Rounding Method: 2
Tax Method: 01
Tax-By-Line: yes
Accrue Tax at Receipt: no
Discount Tax at Invoice: no
Discount Tax at Payment: no
Update Tax Allowed: yes
Update History Allowed: yes
Keep Tax History: yes
Validate VAT Registration: yes
Print VAT Registration: yes
Display Detail on Reports: no
Last Tax Code: 195


An example of one the US Price List is as follows:

Price List: US2002V1
Customer/Analysis Code: US UNITED STATES OF AMERICA
Item/Analysis Code: 100099 GW, FEP, 035X145-ST-S
Currency: USD ------ Item Data ------
UM: EA Price: 0.00 USD
Start: GL Cost: 18.80562 USD
Expire: Site: 2500 Stock UM: EA


An example of one of our GERMAN Price List is as follows:

Price List: DE2002v1
Customer/Analysis Code: DE GERMANY
Item/Analysis Code: 102-0323-323 SILVERSPEED .010
Currency: EUR ------ Item Data ------
UM: EA Price: 0.00 USD
Start: GL Cost: 74.74 USD
Expire: Site: 7777 Stock UM: EA


Is the difference in the Decimal points between GL Cost (in USD) and GL Cost (in EUR) causing this problem ?????

How do we rectify this issue ???