View source for Technical Information (Data Files & Posting Information)

__NOTITLE__
{{Page title|Technical Information}}


'''<big><ins>Data Files:</ins></big>'''

<ul>
        <li>AP1D01.TPS	Invoice Detail File
	<li>AP1D02.TPS	Invoices Selected for Payment
	<li>AP1D03.TPS	A/P Journals Header File
	<li>AP1D04.TPS	A/P Journals Detail File
	<li>AP1D05.TPS	A/P Account File
	<li>AP1D06.TPS	Recurring Invoices File
	<li>AP1D07.TPS	Invoice Payment History File
	<li>AP1D08.TPS	Vendor Master File
	<li>AP1D09.TPS	Extra Vendor Phone Numbers File
	<li>AP1D10.TPS	Vendor YTD Amounts Paid File
	<li>AP1D11.TPS	A/P Checks Database Control File
	<li>AP1D12.TPS 	Full Description of the Invoice File
        <li>APITFR.TPS	A/P Import Invoice File
	<li>APDTFR.TPS	A/P Import Distribution Detail File 
</ul>

'''<big><ins>Record Invoices Posting:</ins></big>'''

'''<ins>Files Affected:</ins>'''

<ul>
                <li>A/P Invoices Files (AP1D01 & AP1D02)
		<li>A/P Purchases Journal (AP1D03 & AP1D04)
		<li>Batch Control File (GL1D09)
		<li>Job Cost Detail Files (JM1D02 & JM1D03)
		<li>Vehicle Detail Files (VM1D02 & VM1D03)
		<li>Commission Detail File (CM1D02)
		<li>G/L Detail History File (GL1D04)*
		<li>G/L YTD Amounts File (GL1D02)*
</ul>

{{Important tip|tip=*NOTE:  The G/L Detail History File (GL1D04) and G/L YTD Amounts File (GL1D02) will be updated based upon the posting method you have selected in the [[G/L Standard Settings File]] in the General Ledger Manager module.  If you have selected the Auto-Posting method, then all the files listed above will be updated automatically.  If you have selected the Manual-Posting method, then the G/L Detail History File (GL1D04) and the G/L YTD Amounts Files (GL1D02) will not be updated until you manually Post Journals in the General Ledger Manager module.}}

'''<ins>Entry in G/L:</ins>'''
<ul>
		<li>Debit to Expense Account
		<li>Credit to A/P Control Account
</ul>

'''<big><ins>Print /Record Accounts Payable Checks Posting:</ins></big>'''

	'''<ins>Files Affected:</ins>'''
<ul>
		<li>A/P Invoices Files (AP1D01 & AP1D02)
		<li>A/P Checks Journal (AP1D03 & AP1D04)
		<li>Invoice Payment History File (AP1D07)
		<li>Vendor Master File (AP1D08)
		<li>Vendor YTD Amounts Paid File (AP1D10)
		<li>Bank Account Check Register (BM1D02)
		<li>Batch Control File (GL1D09)
		<li>G/L Detail History File (GL1D04)*
                <li>G/L YTD Amounts File (GL1D02)*
</ul>

{{Important tip|tip=*NOTE:  The G/L Detail History File (GL1D04) and G/L YTD Amounts File (GL1D02) will be updated based upon the posting method you have selected in the [[G/L Standard Settings File]] in the General Ledger Manager module.  If you have selected the Auto-Posting method, then all the files listed above will be updated automatically.  If you have selected the Manual-Posting method, then the G/L Detail History File (GL1D04) and the G/L YTD Amounts Files (GL1D02) will not be updated until you manually Post Journals in the General Ledger Manager module.}}

'''<ins>Entry in G/L:</ins>'''
<ul>
		<li>Debit to A/P Control Account
		<li>Credit to Cash  Account
</ul>

'''<big><ins>oid Accounts Payable Check Posting:</ins></big>'''

	'''<ins>Files Affected:</ins>'''
<ul>
		<li>A/P Invoices File (AP1D01)
		<li>A/P Checks Journal (AP1D03 & AP1D04)
		<li>Invoice Payment History File (AP1D07)
		<li>Vendor Master File (AP1D08)
		<li>Vendor YTD Amounts Paid File (AP1D10)
		<li>Bank Account Check Register (BM1D02)
		<li>Batch Control File (GL1D09)
		<li>G/L Detail History File (GL1D04)*
                <li>G/L YTD Amounts File (GL1D02)*
</ul>

{{Important tip|tip=*NOTE:  The G/L Detail History File (GL1D04) and G/L YTD Amounts File (GL1D02) will be updated based upon the posting method you have selected in the [[G/L Standard Settings File]] in the General Ledger Manager module.  If you have selected the Auto-Posting method, then all the files listed above will be updated automatically.  If you have selected the Manual-Posting method, then the G/L Detail History File (GL1D04) and the G/L YTD Amounts Files (GL1D02) will not be updated until you manually Post Journals in the General Ledger Manager module.}}

'''<ins>Entry in G/L:</ins>'''
<ul>
		<li>Debit to Cash Account
		<li>Credit to A/P Control Account
</ul>

{{Important tip|tip=Note:  The Accounts Payable check voiding process returns the invoice to its original unpaid status.  If you wish to get rid of the invoice amount, you will need to post a credit memo and then pay it as an offset.  It also shows in Bank Account Manager as voided.}}

'''<big><ins>Merge Recurring Accounts Payable Invoices:</ins></big>'''

Recurring Payables should be merged <ins>MONTHLY</ins>.  This monthly merge does the following:

'''<ins>Files Affected:</ins>'''
<ul>
		<lI>A/P Invoices Files (AP1D01 & AP1D02)
		<lI>A/P Purchases Journal (AP1D03 & AP1D04)
		<lI>Recurring Payables Holding File (AP1D06)
		<lI>Batch Control File (GL1D09)
		<lI>Job Cost Detail Files (JM1D02 & JM1D03)
		<lI>Vehicle Detail Files (VM1D02 & VM1D03)
		<lI>Commission Detail File (CM1D02)
		<lI>G/L Detail History File (GL1D04)*
		<lI>G/L YTD Amounts File (GL1D02)*
</ul>

{{Important tip|tip=*NOTE:  The G/L Detail History File (GL1D04) and G/L YTD Amounts File (GL1D02) will be updated based upon the posting method you have selected in the [[G/L Standard Settings File]] in the General Ledger Manager module.  If you have selected the Auto-Posting method, then all the files listed above will be updated automatically.  If you have selected the Manual-Posting method, then the G/L Detail History File (GL1D04) and the G/L YTD Amounts Files (GL1D02) will not be updated until you manually Post Journals in the General Ledger Manager module.}}

'''<ins>Entry in G/L:</ins>''' 
<ul>
		<li>Debit to Expense Account
		<li>Credit to A/P Control Account
</ul>