Skip to Content
0
Former Member
Apr 24, 2009 at 06:00 AM

Marketing Loan Backlog Report

43 Views

Hi Experts,

I required help on the following process which we follow for issuing out loan items to our customers:

We are distributors of IT products selling to dealers, any time a new product is launched in the market we need to provide few top customers with a demo product for them to get the look and feel of the product. Some of these items are given free of cost and other are given on returnable basis.

In order to process such issue out which are not invoices, we use the following method:

1. As and when an item is issued to a dealer the loan item is transferred to the Loan Warehouse which is a seperate warehouse created in the system.

The reason for creating this being; at any point of time if we needed to know the total stock value lying with our dealers it can be known.

2. When the items are returned by the dealer, we pass an Inventory transfer for items to be received back to the general warehouse. The Inventory Transfer sheet has been modified by our consultants to include the BP code and the name.

Now the issue here is, if at the end of a period we are unable to know the total items which have been issued to each customer in detail.

If we use the Invenotry Posting list, it will not give us the Customer name and code, and there is no knock off of items loaned against items returned.

Recently we have found out that 2 UDF fileds called "Transfer Type" values to be entered is 0- LOAN or 1-RETURN, and Original Docuemnt Number ( which we guess should link back to the original transfer sheet which was used to loan the item) were created in the system.

Is it possible to use the above data to provide a solution either using a query or any other report through which we are enable to generate the required Loan report.

Would appreciate your guidance on this issue.

Regards