Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 Inventory Receipt Txn
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jfbevilaqua
Starting Member

USA
23 Posts

Posted - March 24 2004 :  09:06:08  Show Profile  Visit jfbevilaqua's Homepage  Reply with Quote
Is there a way to perform an Inventory
Receipt Transaction in VP-ASP already or has
someone else already written one to perform
an auditable and verifiable Inventory
Receipt Inventory Control Transaction?
If there is also a front end Purchase Order
module that links into VP-ASP databases that
would be a good thing as well. Thank you.
Any ideas let me know.

John Bevilaqua

Cam
VP-CART Super User

Australia
361 Posts

Posted - March 26 2004 :  04:02:39  Show Profile  Visit Cam's Homepage  Reply with Quote
Hi John,

Can you throw us some more infomoration on these?

Cheers,
Cam

*************************************
Cam Flanigan
YourVirtualStore Sales
e-mail:
http://www.vpasp.com/sales/shopcustcontact.asp
web: http://www.yourvirtualstore.net

Build you own YourVirtualStore!!!
www.yourvirtualstore.net
*************************************
Go to Top of Page

jfbevilaqua
Starting Member

USA
23 Posts

Posted - March 26 2004 :  05:12:18  Show Profile  Visit jfbevilaqua's Homepage  Reply with Quote
Hello Cam,

Sure thing. When a Purchase Order to
replenish stock from a given vendor or
supplier is issued these details should
be recorded as the opposite of a Sales
Order to deplenish stock for an item. You
might even use the shopping cart to pick
out the items for reorder, based on the
onhand quantity. Instead of using a Customer
Code for these Purchase Ordered items you would
use a Vendor or Supplier Code and send them
the Purchase Order via eMail or hard copy.

It would update the OnOrder Quantity for
a given product or item code for the vendor.
When the items on the Purchase Order are
received into the Receiving Department either
on a partial or complete basis, this fact is
also recorded and the OnOrder Quantity goes
down by the quantity received into stock and
the OnHand Quantity goes up by the quantity
received into stock.

The whole process is the reversed image
or mirrored negative template image of the
fulfillment of a Sales Order which reduces
the quantity OnHand when the item is ordered
or shipped.

To make this approach a true Inventory Control
System, you might want to add in either an
Average Cost Calculation that updates a value
at the Product Master level to indicate the
weighted average price paid for the items
received into inventory in order to determine
the contribution to gross profit margin that
occurs when one of these items is actually sold.
You have to also keep an audit trail of these
Inventory Receipt transactions on hand because
some inventory systems use the FIFO or LIFO method
of determining contribution to Gross Profit Margin.
FIFO means first in first out or the assumption
that whatever you sold was the item sitting on
the shelf the longest time period and LIFO is
the assumption that what you just sold was the
item sitting on the shelf for the shortest time.

In theory this should only take a few weeks to write
for someone well versed in VP-ASP coding styles
and design since there is always a close parallel
to each function or process to write in the current
system.

You can also go to http://www.netsuite.com which
is the new name for the Oracle Net Ledger code to
see exactly how a profession Purchase Order system
works and how it interacts with Inventory Balances.

Could this module be sold for as much as Sales Orders
or the Shopping Cart? Not usually, but would it be
worth $100.00-195.00 for Purchase Orders and $100.00-195.00
for a complete Inventory Control function? Quite likely
in fact. The total package would bring VP-ASP into the
realm of a 3 part product offering: Sales Orders, Purchase
Orders and Inventory Control. Next step would be something
like a mini-General Ledger or a link to Quick Books for
this transaction set as well.

Regards,
John Bevilaqua
[email protected]






Go to Top of Page

perryd
Starting Member

USA
9 Posts

Posted - March 26 2004 :  13:12:09  Show Profile  Reply with Quote
Well put John. This would bring VPASP to the next level and have my vote.

Perry Dau
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00