phpBMS

Ticket #28 (assigned enhancement)

Opened 5 years ago

Last modified 19 months ago

Purchasing Module

Reported by: ProDevStudio <azizur@…> Owned by: anonymous
Priority: minor Milestone: Future Releases
Component: phpbms Version: 0.96
Keywords: helpWanted Cc:

Description (last modified by brieb) (diff)

I am working on a module to track my suppliers, purchases from suppliers and eventually get to accounting sections. if anyone can give some assistant in development please let me know.

Attachments

purchasesmodule.zip Download (238.6 KB) - added by Andi Martin 4 years ago.
It's a start at least
purchasesmodule.2.zip Download (238.6 KB) - added by Andi Martin 4 years ago.
Forgot to add the sort order of purchase_order.id on the tabledef id of 1001 of the last one
purchasesmodule.3.zip Download (236.7 KB) - added by Andi Martin 4 years ago.
0.3A - have updated any ids required by the module within the range of 28000 and the module id to 28 same as the Trac ticket ID.
purchasesmodule.4.zip Download (237.2 KB) - added by Andi Martin 4 years ago.
Purchases Module v0.4 - this file sorts out a few minor bug corrections. The next version will involve the removal of the extra files that are not required. After this, i'll be looking for suggestions from yourselves as to where to take the final version.

Change History

Changed 5 years ago by ProDevStudio <azizur@…>

  • keywords helpWanted, added

Changed 5 years ago by brieb

  • keywords helpWanted added; helpWanted, suppliers, purchases, accounting , expense removed
  • description modified (diff)
  • summary changed from trying to track my suppliers, purchases from suppliers and eventually get to accounting sections to Purchasing Module

We would love to see what you have so far. Can you attach it to the ticket? We acan also allocate some forum sections to module development, and give a modules area in the SVN that you can use for your development.

Changed 5 years ago by anonymous

  • version changed from 0.61 to 0.62

Changed 5 years ago by brieb

  • milestone changed from unknown to 1.0

Changed 5 years ago by Don Corleone

If I can help you anything just tell me. The module you work on is interested by me. You can find me under this name in the official phpBMS forum.

Changed 4 years ago by Andi Martin

It's a start at least

Changed 4 years ago by Andi Martin

Forgot to add the sort order of purchase_order.id on the tabledef id of 1001 of the last one

Changed 4 years ago by Andi Martin

0.3A - have updated any ids required by the module within the range of 28000 and the module id to 28 same as the Trac ticket ID.

Changed 4 years ago by Andi Martin

  • owner changed from brieb to Andi Martin

I wouldn't go installing on live systems yet, however, I've modified brieb's original code for clients/sales orders to act with purchases and purchase orders. It still needs tidied up a lot and bits and pieces taken out, however, it's a start.

Changed 4 years ago by anonymous

  • status changed from new to assigned
  • owner changed from Andi Martin to anonymous

Changed 4 years ago by Andi Martin

Purchases Module v0.4 - this file sorts out a few minor bug corrections. The next version will involve the removal of the extra files that are not required. After this, i'll be looking for suggestions from yourselves as to where to take the final version.

Changed 4 years ago by anonymous

there is a problem with the purchase form, the lookup turns you to a missing page

Changed 3 years ago by Björn Rust

Expanding on the pervious post.

When attempting to add a new record, it returns with this error;

Fatal error: Class 'inputAutofill' not found in C:\[filepath]\purchase_orders_addedit.php on line 86

While clicking the Supplier> Quick View returns this error;

Fatal error: Class 'inputAutofill' not found in C:\[filepath]\quickview.php on line 56

This module is the only thing keeping us from implementing PHPBMS, can someone suggest a remedy. (we are looking forward to version 1.0)

Changed 2 years ago by genius.developers@…

  • version changed from 0.62 to 0.96

I have just installed the purchase Module in my system and I am getting below SQL error. Can anyone tell me what I am missing here?

Statement: SELECT DISTINCT purchase_orders.id as theid,concat(purchase_orders.type,"p") as "_group1" , purchase_orders.id as "id", purchase_orders.readytopost as "RTP", purchase_orders.type as "type", purchase_orderstatuses.name as "status", purchase_orders.weborder as "web", if(purchase_orders.type="purchase_order",purchase_orders.purchase_orderdate,purchase_orders.orderdate) as "date", concat("<strong>",if(suppliers.lastname!="",concat(suppliers.lastname,", ",suppliers.firstname,if(suppliers.company!="",concat(" (",suppliers.company,")"),"")),suppliers.company),"</strong>") as "supplier name / company", paymentmethods.name as "payment", if(purchase_orders.type!="VOID",purchase_orders.totalti,"-----") as "total", if(purchase_orders.type!="VOID",purchase_orders.totalti-purchase_orders.amountpaid,"-----") as "due" FROM (((purchase_orders INNER JOIN suppliers ON purchase_orders.supplierid=suppliers.id) INNER JOIN purchase_orderstatuses ON purchase_orders.statusid=purchase_orderstatuses.id) LEFT JOIN paymentmethods ON purchase_orders.paymentmethodid = paymentmethods.id) WHERE purchase_orders.type+0<3 OR (purchase_orders.type = 'purchase_order' AND purchase_orders.totaltni != purchase_orders.amountpaid) ORDER BY concat(purchase_orders.type,"p"), limit 0, 45;

Changed 2 years ago by brieb

  • milestone changed from 1.0 to Future Releases

Changed 20 months ago by kannanog

hai i have purchases modules. but i don't know how to add these module in phpbms. if anyone know how to add this module means just tell me...

Changed 19 months ago by kannanog@…

i am getting the following error when i am go to install purchases module. Fatal error: Call to undefined function createTables() in D:\AppServ?\www\phpbms\modules\purchases\install\install.php on line 65

Note: See TracTickets for help on using tickets.
Scanned by Orvant Copyright © 2010 Kreotek, LLC. All Rights reserved.