BOSS Corporation

Home    Site Map    Contact Us 


Better Organization Service Solutions

 

On Purging AP and PO

Depending on your installation, you may not find a lot to purge. Here are just a few items to keep in mind:

If any of the invoices deal with 1099’s, they won’t purge.

If they are related to Oracle Projects, they will not purge.

If you haven’t cleared the check that paid the invoice, you won’t purge.

If your PO’s are not "CLOSED" or "FINALLY CLOSED" you won’t purge.


If you update the payment terms on an invoice, Payables recalculates the scheduled payment for the invoice. Thus, you must reenter any manual adjustments you made to the previous scheduled payment. For example, if you updated the payment priority on a particular scheduled payment and then changed the payment terms, Payables would recalculate the scheduled payment using the same payment priority defaults as before and you would need to redo your updates.


The only way around the restriction that vendor names must be unique, is to make the names slightly different. Can you add an initial, or some other character to one of the names? The only thing to do is use a mix of initials, abbreviations, nicknames, etc. Oracle A/P does not allow identical names because everything is keyed off the vendor name, not the vendor number. It makes some things easier, such as vendor queries and invoice entry.


The program which prints EFT output is linked with the EFT document definition. And all format programs are defined under payment programs. Here are the details of setup:

Create different files to different countries if the format is different. There are few setup steps involved :

  • 1. Initiate a contract with your bank for setting up EFT. You should be getting login, bank account #, transmission #, dialing number and other details. Once you have these details, you can dial and connect to the bank’s system.

  • 2. In NavSetupPaymentProgram, Create a new format program which will create EFT batch compliance with the Bank format. You may have to create a new build program.

  • 3. In NavSetupPaymentFormat, select EFT from the quickpick of the name field in the Payment Method Zone and enter payment format details including build and format program.

  • 4. Enter proper bank account details including the GL account under required branch in \NavSetupBank

  • 5. In the Payment Document Zone, Enter the document name, starting and ending number, format program name and other related details. You need to create one descriptive flexfield to store transmission # assigned by the bank.

  • 6. In the vendor screen. I think payment goes to vendor site, So enter bank account details at the vendor site level. Payment details at the vendor site level, define payment method as EFT. You need to create one descriptive flexfield for pre noting status. Once these setups are ready, for an invoice batch, select invoices for payment through EFT, Format the payment (which should have a link to payment format). The format payment process will create an EFT batch which should be sent to the bank through modem and bank interface.


There are four alerts that ship with the Accounts Payable application. Check out appendix A of the AP Reference Manual. The alerts are designed to send e-mail and process responses to/from buyers and requestors. The periodic alerts are triggered weekly and detect when an invoice goes on hold for price, purchase quantity, receipt quantity, or missing receipt.

 

 

 ©2007 BOSS Corporation.              
All rights reserved.