Tracking of Stock & Cheque/Cash with respect to sales employees

[Former Member]

Hi all,

I am in an implementation project with ECC5. It is a cigarette and tobacco manufacturing company. The business keeps track of stock movement and as well as cash and bank receipt from customer as per sales employees. That is for example they keep track of stock when the finished good is coming out from depot and the depot clerk hands over the material to sales employee to deliver to customer, in this stage the stock should be recorded against employee. After that when the sales employee delivers the material to customer then the finance entry will be for stock with sales employee credited.

When the sales employee receives the cheque from customer at that time the customer account will not be credited till the cheque is not cleared. The business will deposit the cheque to depot clerk , the depot clerk will deposit the cheque to bank and when the bank stmt will come at that time the customer account will be credited. In this cases also the business wants to keep track of cheque/cash what the sales employee has collected from customer.

I am giving here the details of transaction in the cases of stock movement and as well cheque receipt and finance entry.

Sales transaction entries

Terminology:

ESR Excise Location

DEPOT Depo

SALES REP Territory

1 Stock issue from ESR to DEPOTS

1 Delivery Note at ESR

2 GRN at DEPOT

2 Stock issue from DEPOT to SALES REP

1 INT Delivery Note

3 SALES REP activities

1 Cash or Cheque sales

2 Daily sales record

Entries in goods movement:

1 When stock issued from ESR to DEPOT

FG Stock Depot Dr

FG Stock ESR Cr

( Should be tracked Qty and Value)

2 When stock issued from DEPOT to SALES REP

FG Stock Sales Rep Dr

FG Stock Depot Cr

( Should be tracked Qty and Value)

3 When SALES REP is selling stock

Cost of Goods sold Dr Customer account

Dr

FG Stock Sales Rep Cr Sales Revenue Cr

( Applicable taxes and SALES REP details should be tracked)

CHEQUE ENTRIES

4 When SALES REP is cllected CHEQUE from customer

SALES REP Dr

SALES REP Cheque Holding Cr

5 When SALES REP is deposited CHEQUE to DEPOT

DEPOT Cheque Holding Dr

SALES REP Cr

6 When DEPOT is deposited into bank

BANK Dr

DEPOT Cheque Holding Cr

7 When Cheque realises

SALES REP Cheque Holding Dr

Customer account Cr

Cash Entries

4 When SALES REP is cllected cash from customer

SALES REP Dr

Customer Cr

5 When SALES REP is deposited CASH to DEPOT

DEPOT Dr

SALES REP Cr

6 When DEPOT is used some cash for office expenses and balance

deposited

into bank

DEPOT OFFICE CASH Dr

BANK Dr

DEPOT Cr

(Some expenses kept for office expenses and balance deposited into bank)

To track the stock with sales employees we have decided each sales employee will be considered as storage location and we will define business areas with the combination of plant and storage location and these business areas will be as against the sales employee and when posting the cheque and cash transaction the business areas will be accepted and we will generate the report against sales employees. The business requires the stock and cheque/cash reconciliation report as against the sales employees.

We want your input and suggestion in this scenario and will be waiting for your reply.

If you need any clarification please let me know.We are not implementing HR.

Thanks & Regards,

Mitra

[Former Member]

Hi,

Good morning and greetings,

I dont think so that there is a standard report by which you can get the info...Better to do a bespoke development or use SQVI transaction to map the TABLE - TABLE joint option to get the requirement.

Please reward points if found useful

Thanking you

With kindest regards

Ramesh Padmanabhan