RE: Vat Tax in AFI

[Michael Berman <michael.berman@xxxxxxxxxxx>]

The answer is to amend your AFI rules to include the Credit using the VAT70
and VAT50 fields.
The Account number is blank as the account is derived from the VAT Codes
maintenance.
Note:  The VAT Postings do not consolidate.
Please don't forget the VAT on Charges.
                                                                     
The posting definitions are:

Posting description . . . . . . Credit Sales Tax                     
Value field to post . . . . . ? VAT70      Line VAT amount           
Reverse sign of posting?  (1/0) 1                                    
Consolidatable posting?   (1/0) 0                                    
Consolidation control field . ?                                      
Default posting account . . . ?                                      
Account generation rule . . R/?                                      
Quantity field to post  . . . ?                                      
                              
                                                                      
Posting description . . . . . . Charges - Tax                        
Value field to post . . . . . ? VAT50      Charges VAT amount        
Reverse sign of posting?  (1/0) 1                                    
Consolidatable posting?   (1/0) 0                                    
Consolidation control field . ?                                      
Default posting account . . . ?                                      
Account generation rule . . R/?                                      
Quantity field to post  . . . ?

                                                                    

Michael Berman
Email michael.berman@geac.com.au
(big bad GEAC person)
Phone 0419 324 558


-----Original Message-----
From: Randy Stratton [mailto:rstratton@alsons.com]
Sent: Wednesday, November 22, 2000 7:40 AM
To: 'JBAUSERS-L@midrange.com'
Subject: Vat Tax in AFI


We are attempting to use vat tax within JBA 3.5.2 SP3.  The issue is how do
we get the vat tax to post to the account number in vat tax setup in G/L?
The report below shows the AFI Suspense posting.  If we set this up in AFI,
AFI tells us the vat tax is posted through the G/L vat tax.  Any help would
greatly appreciated.  

Consolidated Posting           AC   9999999            11/21/00      11

 ________________               _______      ___________________
______   ____                     
 Cons. val.:    01                    01190        A/R TRADE FOREIGN
106.66                            
 Cons. val.:    01                    04301        MAT COS AT STANDARD
30.00                            
 Cons. val.:    01                    0473         MATL FIN GDS ENDING
30.00-                           
 Cons. val.:    12                    0300100    SALES,PRODUCT TRADE
99.68-                           
 Journal Balancing posting      9988         AFI SUSPENSE
6.98-       ** SEE REPORT NOTE  
                                                                


  
 Randy Stratton
Director IS
Alsons Corporation
517-439-1411
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---