How to Create Invoices and Credit Memos Without Updating Item Quantity through Phantom Invoice

How to Create Invoices and Credit Memos Without Updating Item Quantity through Phantom Invoice

Q - How can we create invoices and credit memos that don't hit the Item Transaction file but do hit the I/M Distribution File (IMDISFIL)?

A - Depending on your intention, there could be multiple solutions:

Non-Stock Item

Based on your description, you can set up non-stock items as a solution.  "Non-stock item" means it is a non-inventory item that is not kept on the shelf, so the Quantity On Hand is always zero. Even though a non-stock item will not have a Quantity On Hand, the system will still update to the I/M Distribution File (IMDISFIL).  See the sample screen below to see how a non-stock item is set up:


Phantom Invoice

If a non-stock item will not work for you, then you can consider using a "Phantom" invoice to resolve the issue. Go to Global Setup -> Cop-Func -> Order Header Screen, and answer "Y" to the following flag: 

    1. Use Phantom Invoices? 

Then the following window will show up, asking you to further define "phantom":



If I understand you correctly, you will answer "Y" to everything except "Update I/M Item & Inv Location Files ?"   See below:

Update A/R Open Item File ?              Y
Update A/R Distribution File ?           Y
Update A/R Customer File ?               Y
Update A/R Commission Due File ?         Y
Update A/R Salesman File ?               Y
Update A/R Tax Files ?                   Y
Update I/M Distribution File ?           Y
Update I/M Item & Inv Location Files ?   N
Update COP Sales History Trx File ?      Y
Update COP Invoice History Files ?       Y
Update Job History File ?                Y
Update COP Inv. Lot History File ?       Y
Update I/M Serial/Lot Trx File ?         Y  

Then, during order entry, you will see the flag "Phantom."  If you answer "Y," then that phantom order or invoice will post according to the Global Setup. See sample screen below :


Keep in mind that the definition of "Phantom" may be different based on your Global Setup.  In the past, we have seen our users use "Phantom" invoices for the following scenarios:

  • Proforma Invoicing - A proforma invoice is not a real invoice.  In that case, you may set all update flags in Global Setup to "N."
  • Brokerage Firm to Track Commission Due - In that case, you may set all update flags to "N" except "A/R Commission Due File" and "A/R Salesman File."
  • Tracking Consignment Inventory - In that case, you may set all update flags to "Y" except "I/M Distribution File." Since it is not your inventory, there is no inventory and COGS (Cost of Good Sold) distribution. The actual COGS will be handled as a journal entry manually on a month-to-month basis.  Sometimes, the party providing you with the consignment inventory may perform the A/R collection.  Then you will set the update flags in the A/R module to "N."
One key thing to remember is that you can only pick one definition for your "phantom" invoice. You can't have different kinds of "phantoms" on an order-by-order basis.





    • Related Articles

    • How to Create Credit Memo from Invoice History

      Release Date 6/19/17 Modify Date 10/17/24 Version: 7.x & up Q - I notice that in the V7.3 release notes, you provided the ability to create a COP Credit Memo from invoice History. What menu is this feature accessed from? A - You can create a credit ...
    • Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd

      Release Date - 11/21/17 This feature allows the user to control whether the customer sales period-to-date and year-to-date are updated when a debit memo is posted from Sales & Cr/Dr Memo processing. This feature is enabled through a new A/R Global ...
    • I Am Running Out of Invoice Numbers -- I Need Direction to Archive Invoices

      Q: Within the next 6 months we will run out of invoice numbers. I don't want to purge my invoice history because it contains valuable data that I would like to go back to in the future. So I would prefer a method to archive my invoice history instead ...
    • Feature - Import Contacts Without Updating Customers

      Release Date: 3/18/2024 Version: 8.5 and Above Background This article is an update to the main article on eContact Imports. We will succinctly summarize the main article in this section, as well as the new feature that replaces the older system. ...
    • Feature - Added Phantom Locking to Item File Maintenance

      Release date: 6/4/2018 In the past, when a user brought up an item master record in Item File Maintenance Change mode, the item record would be locked. Any other users who tried to update that item record -- including quantity on hand, on order, or ...