Help for Using Absolute Accounting Absolute Advantage is the leading FileMaker® Pro developer in the Los Angeles area Written entirely in FileMaker Pro, Absolute Accounting is a high-volume, multi-user accounting system.

Back to Help Main Menu Email Help Request Absolute Advantage Home Absolute Accounting Integration - AR Transactions AR Integration is done through a filter file: AR Transactions (AR_GL_Import_Abs.fp5) The AR filter allows you to import Sales transactions into Absolute Accounting. These typically include Sales Invoices and Credit Memos. All syncing is done from the “line item” file (ie, “Invoice Line Items”) NOT the “header” file. This allows each line item to be posted to a different GL Account. Header information is “attached” to each related line item with a calculation field. The import filter then extracts the header information as required. To do this you need to create a set of calculation or input fields named EXACTLY as specified and point the “Import From Invoice LI” script in “AR_GL_Import_Abs.fp5” to do a “Matching Name” import from your line item file. You must track which new invoices need to be posted, find all their line items, and then trigger the “Import From Line Items [Master Script]” in “AR_GL_Import_Abs.fp5”. The Import filter will do the rest - all of your sales transactions will appear in a new AR Batch in Absolute Accounting. This process can also be used to bring initial Sales information when first configuring Absolute Accounting. It is recommended that you "lock" posted invoices so that they cannot be modified. View AR Fields / AP Integration / Contact Integration / GL Integration Privacy Policy: Absolute Advantage maintains a strict "No-Spam" policy. We do not sell, rent, or otherwise give your e-mail address, name or any other information to any third-party, without your consent. For more information, please see our Privacy Policy.

 Questions? Email us!
Absolute Advantage, Inc., est. 1987. Last web update Feb., 2004
Site Map