Register    Login    Forum    Search    FAQ

Board index » General Usage » Inventory




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: stock Control for customers
 Post Posted: Mon Jan 23, 2012 8:12 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Dave,

How is it possible for you to control your stock in a situation when your customers comes to your store to buy say 20 unit of your product and pays for them but carries only 13 unit balance 7 units. how do I use phreedom to track this procedures.

thanks.

popsicles1


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Mon Jan 23, 2012 7:59 pm 
Offline

Joined: Wed Nov 21, 2007 10:30 am
Posts: 569
He pays for 20 units, takes only 13 with him?

And has credit for 7 units?

_________________
Alvin


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Thu Jan 26, 2012 7:20 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Alvin,

Yes, he pays for 20units and takes only 13 units.
Yes, he has a credit of 7 units.

Now the question is how do I use Phreedom 3.3 to track this to reflect that the customers still has a balance of 7 units to collect.

pls, help.

thanks.
popsicles1


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Thu Jan 26, 2012 6:40 pm 
Offline

Joined: Wed Nov 21, 2007 10:30 am
Posts: 569
A back order system for the customer.

I think is would be a good feature.

_________________
Alvin


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Fri Jan 27, 2012 8:44 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Alvin,

how do i get the backorder system.

I need it.

thanks.
popsicles1


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Fri Jan 27, 2012 10:30 am 
Offline

Joined: Fri Aug 28, 2009 8:50 am
Posts: 186
Location: Miami, FL
Currently there is no backorder system. Nevertheless, you can handle it this way:.
1. Create a sales order for the total quantity.
Customers->Sales Orders
2. Invoice the quantity of items delivered.
Customers->Sales Order Manager->Press Invoice button
3. Accept payment for the total quantity
Banking->Customer Deposits
4. Apply the deposit to the invoice
Customer->Invoice Manager->Press payment icon

The remainder of the order will appear on the inventory list and sku screen as Qty on Sales order. Then, when you deliver the rest of the order,
5. Invoice the remaining quantity
Customers->Sales Order Manager->Press Invoice button
6. Apply the remaining portion of the initial deposit to the invoice
Customer->Invoice Manager->Press payment icon

_________________
Ruben.


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Wed Feb 01, 2012 9:09 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
Very good Ruben. Good procedure.

You should an also be able to do it this way:
1. Create a Sales Order for 20 units.
2. Create and invoice for 13 units.
3. Receive payment for 20 units. This will leave the invoice open as there is still a balance left (negative as they overpaid).
4. When they take delivery for the remaining 7 units, create an invoice and Save (Do not press the payment icon or the credit will no show up).
5. Banking -> Customer Receipts -> Select customer. You should see the newly generated invoice and the over payment from the first invoice. Check both boxes (for a net zero total) and Save the receipt.

Dave


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Sat Feb 04, 2012 8:21 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello,
thanks very much Dave and Reuben. It is a very wonderful solution. I really appreaciate it. thanks once again.
Please Dave, you still have not answered my question in Receivables with topic "POS ERROR". Please help me out. I am stock.

thanks
Popsicles1


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Tue Apr 24, 2012 8:06 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Dave and Reuben,

Thanks for your reply on how to control stock of customer who buys and picks them twice. How do I handle this same issue if the customer decides to pick the balance 7 ( as used in my example) in 3 instalments. say from the 7, he picks 3 packs, then it balances 4, and when he comeback he either picks the 4 or decides to pick 2 cartons.
When I try to carry out this proceduce, it works but when I print the customer's report, the balance due, will be showing 0.00, when I am supposed to be owing the customer the said amount of the balance 4 cartons which he has not carried.
What is the way around this.

Thanks,

Popsicles1.


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Tue May 01, 2012 3:49 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
This sounds more like a report problem versus a journal problem. If you open the Sales Order, it should show the number ordered and the number invoiced. You should be able to invoice from the Sales Order as many times as you want until all items have been invoiced. If the report is not reflecting the proper balances, I'll need to address that issue separately. Let me know.

Dave


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Thu May 17, 2012 11:43 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Dave,

thanks for your all your support. I just discovered that using Sales Order, it deducts the stock accurately but the challenge here is the Customer Statement. Take for example, a customer buys 50 cartons and on the day of purchase, he took 20 cartons, and then 10 cartons and then another 10 cartons leaving a balance of 10 cartons. The balance carton is supposed to be reflected in monetary terms in the Statement as money owe the customer but it shows 0.00 in dollar even when I have changed the currency to my local currency.

I attached a file to explain the above scenario.
How do I correct this?

thanks

popsicles1


Attachments:
Customer Statement.jpg
Customer Statement.jpg [ 117.32 KiB | Viewed 381 times ]
Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Fri May 18, 2012 3:31 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
Sales Order information shouldn't show on the statement as a Sales Order 'reserves' the product. It's not until an invoice is generated that it will show up. If the customer took delivery in parts, and you invoice in parts. Each part should show up on the statement. I cannot understand your statement unless I know what the transactions behind the statement listing are.

Dave


Top 
 Profile  
 
 Post subject: Re: stock Control for customers
 Post Posted: Wed May 23, 2012 6:05 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Thanks Dave for your reply.
This is the explanation of the attached statement i sent to you.
The Cash/Receipts Journal (18) (DP20120517) N191,625.00 is the total amount for the 50 cartons that the customer paid when he first came to buy.
I raised a Sales Order for the 50 cartons and Invoiced 20 cartons (Invoice No. 26) which he carried on that very day. He paid for everything which I stated above (191,625.00).
the 20 Cartons invoice is Sales/Invoice Journal (12) --76,650.00 (invoice No. 26)
The next time he came he carried 10 cartons Sales Invoice No. 27 - N38,325.00.
The next time he came he carried 1o cartons Sales Invoice No. 28 - N38,325.00.
He is supposed to have 10 cartons balance, which statment is supposed to be like this.
down payment for 50 cartons (191,625)
first invoiced 20 cartons 76,650 (114,975)
Second Invoiced 10 cartons 38,325 (76,650)
Third Invoiced 10 cartons 38,325 (38,650)
Statement Balance is supposed to be -N38,650.00 as amount we are owing the customer. but it is saying that it is 0.00 balance which is not correct.

Please help as it will negatively affect the customer statements sent to such customer which the statement is requested for.

Thanks.

expecting your response.

Popsicles1.


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 13 posts ] 

Board index » General Usage » Inventory


Who is online

Users browsing this forum: No registered users and 0 guests

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron