Perpetual Inventory |
Top Previous Next Xebra Home |
If you need to setup a Customer Owned inventory structure for the purposes of keeping a credit for releases of customer owned product that are billed at the time of release, this is how we suggest you do it: Setup Create a Master Customer record. We will use XETEX for this example. Create a Warehouse record for the customer owned product. This will create Customer and Vendor records automatically. The address for these records should be the physical location of the property that will hold the customer owned products. Create the Item codes and Control records for this Master Customer.
Processing CSI Releases Process releases through CSI when requests are made. Choose to Create a Billing Job after shipping the releases. Invoice the jobs that are released, which will list the products with the price that you want to collect and the cost that you will use as a credit for the Master Customer. Purchasing New Inventory Run the Vendor Sales Journal report from the Reports node. Enter today's date in the To: date field, and enter the Master Customer's warehouse code for the Vendor. Click OK. Note the total cost from the report, which represents the credit that is due to the customer. Create a billing job to purchase the customer-owned items. Add a line item for the Credit. The Credit line item should have the same cost and price, which will be equal to the negated total from the report. In this case, -$100. The Vendor for the Credit line item should be the Warehouse code for the master customer, which is XETEX-WHS. Receive the vendor invoice in to the system. Click Yes to the question "Would you like to receive items from this job into Customer Specific Inventory?" and follow the screens to receive the item, but set the cost to be the per unit value for the credit to the master customer. Set the price to be the per unit value that includes any margin that you need for warehouse fees like pick and pack charges. Invoice the customer for the job to collect payment for the initial purchase of product. The total due from the customer will be the total for the product less the credit that they are due. |