web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Completed Work Order deletes unused serial inventory

[rfthomas <rf...@as...>]

Andrew,

 

The number issued should have been 5, my error.

 

For all non-controlled items we utilize auto issue.  We then manually adjust inventory for losses.

 

We see no clean mechanism to return unused issued items to inventory.  The only means involves making a manual inventory adjustment, i.e. returning the item to inventory.  We understand that items could be consumed (used/damaged) in manufacture and not be returned to inventory.

 

Another problem that is created is the costing for the work order is wrong due to the all items issued are assumed to be consumed by the work order creating incorrect costs of manufacture.

 

We could probably get around this limitation by only issuing items one at a time and only receiving completed items one at a time, i.e. issue one serial number, receive one finished item, so on and so forth until the desired quantity has been produced.  The way the system is currently designed this is very labor intensive and would slow down production appreciably.  Another method would be to create an individual work order for each piece.  Again the extra data entry becomes an issue when there is no automation for creating such.

 

Handling scrap and MRB is another area of challenge.

 

We will look at making the script changes that you have outlined.

 

Sincerely,

Robert F. Thomas



 44 Industrial Way 
Norwood, MA USA 02062
*  Office Phone - (781) 329-9200
* mail to: rf...@as...

 

 

From: Andrew Galuski [via webERP accounting] [mailto:ml-...@n4...] 
Sent: Thursday, March 10, 2016 2:59 PM
To: rfthomas <rf...@as...>
Subject: Re: Completed Work Order deletes unused serial inventory

 

Robert, 
Just a few comments. 
I assume when you said " Work Order Issue -7 New quantity 2" you meant ' Work Order Issue -5 New quantity 2" since previously you said "Issue 5" 

Returning Unused items to inventory should be a manual step I believe (Reverse the issue).  You cannot assume the items are going back into inventory.  They may have been scrapped/damaged etc.  We have the possibility of loss (not 100% yield). 
You should see this anomaly in the W/O Costing screen as a usage variance.  Used more than expected 

It sounds like what you are looking for would be a new 'module' or method of consumption,  Require each raw material that is serialized or batched to be input for each Serial or Batch produced.  So the issue would actually be done during receipt instead of as 2 steps.  Or you could still do 2 separate steps and then 'allocate' the raws to the finished good (like you allocate cash to multiple invoices in A/R).  You would need a method to allow for loss (Product issued or damaged during manufacturing).  Theses issues would remain unallocated but be noted as not used (to force everything put in to be noted).   

As for your "Demand" 0 instead of 3 you might try to replace the code in SelectProduct.php that looks like this (might be slightly different based on version) 
$sql = "SELECT SUM(qtypu*(woitems.qtyreqd - woitems.qtyrecd)) AS woqtydemo 
                FROM woitems INNER JOIN worequirements 
                ON woitems.stockid=worequirements.parentstockid 
                INNER JOIN workorders 
                ON woitems.wo=workorders.wo 
                AND woitems.wo=worequirements.wo 
                INNER JOIN locationusers ON locationusers.loccode=workorders.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1 
                WHERE  worequirements.stockid='" . $StockID . "' 
                AND workorders.closed=0"; 
$ErrMsg = _('The workorder component demand for this product cannot be retrieved because'); 
$DemandResult = DB_query($sql, $db, $ErrMsg); 
if (DB_num_rows($DemandResult) == 1) { 
        $DemandRow = DB_fetch_row($DemandResult); 
        $Demand+= $DemandRow[0]; 
} 

With something like this. (Not tested) 
$sql="SELECT SUM(qtypu * (woitems.qtyreqd - woitems.qtyrecd)) as reqqty, 
                        SUM( - qty ) as issqty 
                FROM worequirements INNER JOIN woitems 
                ON woitems.wo=worequirements.wo 
                AND woitems.stockid = worequirements.parentstockid 
                INNER JOIN workorders on workorders.wo=woitems.wo 
                LEFT OUTER JOIN stockmoves ON stockmoves.type =28 
                AND reference=woitems.wo 
                AND stockmoves.stockid='" . $StockID."' 
                WHERE workorders.closed=0 
                AND worequirements.stockid='" . $StockID."'"; 

$ErrMsg = _('The order details for this product cannot be retrieved because'); 
$RequirmentsResult = DB_query($sql,$db,$ErrMsg); 
$WoResult = DB_query($sql,$db,$ErrMsg); 
$WoRow = DB_fetch_row($WoResult); 
if ($WoRow[0]!=null){ 
        $ReqQty =  floatval($WoRow[0]); 
} else { 
        $ReqQty = 0; 
} 
if ($WoRow[1]!=null){ 
        $IssQty =  floatval($WoRow[1]); 
} else { 
        $IssQty = 0; 
} 
$Demand+= ($ReqQty - $IssQty); 


Best Regards, 
Andrew Galuski 


-----Original Message----- 
From: rfthomas [mailto:[hidden email]] 
Sent: Thursday, March 10, 2016 11:30 AM 
To: [hidden email] 
Subject: Re: [WebERP-developers] Completed Work Order deletes unused serial inventory 

To provide further detail: 

Work Orders do not properly deal with serialized inventory 

To demonstrate the problem create the following two inventory items: 

TEST_SERIAL – purchased/controlled/serial number TEST_SERIAL_M – manufactured/controlled/serial number 

Create a BOM for TEST_SERIAL_M with one entity: 

TEST_SERIAL QTY 1, Not Auto Issued 

Add 7 of TEST_SERIAL to inventory, S/N 1, 2, …, 7 

Create a Work Order to manufacture 5 of TEST_SERIAL_M. 

Issue 5 of TEST_SERIAL to the newly created work order, using serial nos. 1, 2, 3, 4, and 5 

Receive 2 of TEST_SERIAL_M where the received items have serial nos. 1 and 2 

When one looks at inventory for TEST_SERIAL: quantity on hand = 2, quantity demand 3, available -1.  This is the first error in inventory: The demand is 
0 since 5 parts have already been issued to the work order to manufacture TEST_SERIAL_M and there are 2 parts available.  When one examines serial numbers there are serial numbers 6 and 7. 

Inventory movements show: 
Stock Adjustment +7 New quantity 7 
Work Order Issue -7 New quantity 2 

The receive function does not force entry of the serial numbers of TEST_SERIAL when receiving TEST_SERIAL_M.  This is incorrect since the reason serial numbers as well as batch/lot numbers is to provide component traceability.  The receive function must properly allocated the material and make a proper move notification.  Such never occurs. 

After the work order is closed, not having consumed all of the issued items, unused items are never returned to inventory.  Three unused serial number items are deleted from the system with no trace. 

There should be 5 of TEST_SERIAL in inventory and 2 in TEST_SERIAL_M parts in inventory.  If the 2 TEST_SERIAL parts in TEST_SERIAL_M parts need to be tracked back, reports could be written to generate the migration of the part. 

In the US, there are regulations that require traceability of components. 
The FAA (Federal Aviation Administration), DOD (Department of Defense), FDA (Food and Drug Administration), among others require such.  An example are components going into a jet aircraft engine:  Each piece of raw material is tracked by Foundry/lot, then serialized when cut into blanks, and traced throughout manufacture to the completed rotor and engine.  One would expect that such is also required by other countries. 
Any thoughts/suggestions on what can be done to meet these requirements and correct the inventory errors? 




-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Completed-Work-Order-deletes-unused-serial-inventory-tp4658530p4658553.html
Sent from the web-ERP-developers mailing list archive at Nabble.com. 

------------------------------------------------------------------------------ 
Transform Data into Opportunity. 
Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. 
Click to learn more. 
http://pubads.g.doubleclick.net/gampad/clk?id=278785111 <http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140> &iu=/4140
_______________________________________________ 
Web-erp-developers mailing list 
[hidden email] 
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
------------------------------------------------------------------------------ 
Transform Data into Opportunity. 
Accelerate data analysis in your applications with 
Intel Data Analytics Acceleration Library. 
Click to learn more. 
http://pubads.g.doubleclick.net/gampad/clk?id=278785111 <http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140> &iu=/4140
_______________________________________________ 
Web-erp-developers mailing list 
[hidden email] 
https://lists.sourceforge.net/lists/listinfo/web-erp-developers



  _____  

If you reply to this email, your message will be added to the discussion below:

http://weberp-accounting.1478800.n4.nabble.com/Completed-Work-Order-deletes-unused-serial-inventory-tp4658530p4658557.html 

To unsubscribe from Completed Work Order deletes unused serial inventory, click here <http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658530&code=cmZ0QGFzdGhvbWFzLmNvbXw0NjU4NTMwfC0xODc0MzAxMjU=> .
 <http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> NAML 



image003.png (51K) <http://weberp-accounting.1478800.n4.nabble.com/attachment/4658558/0/image003.png>




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Completed-Work-Order-deletes-unused-serial-inventory-tp4658530p4658558.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Completed Work Order deletes unused serial inventory

[Andrew G. <aga...@re...>]

Robert,
Just a few comments.
I assume when you said " Work Order Issue -7 New quantity 2" you meant ' Work Order Issue -5 New quantity 2" since previously you said "Issue 5"

Returning Unused items to inventory should be a manual step I believe (Reverse the issue).  You cannot assume the items are going back into inventory.  They may have been scrapped/damaged etc.  We have the possibility of loss (not 100% yield).
You should see this anomaly in the W/O Costing screen as a usage variance.  Used more than expected

It sounds like what you are looking for would be a new 'module' or method of consumption,  Require each raw material that is serialized or batched to be input for each Serial or Batch produced.  So the issue would actually be done during receipt instead of as 2 steps.  Or you could still do 2 separate steps and then 'allocate' the raws to the finished good (like you allocate cash to multiple invoices in A/R).  You would need a method to allow for loss (Product issued or damaged during manufacturing).  Theses issues would remain unallocated but be noted as not used (to force everything put in to be noted).  

As for your "Demand" 0 instead of 3 you might try to replace the code in SelectProduct.php that looks like this (might be slightly different based on version)
$sql = "SELECT SUM(qtypu*(woitems.qtyreqd - woitems.qtyrecd)) AS woqtydemo
		FROM woitems INNER JOIN worequirements
		ON woitems.stockid=worequirements.parentstockid
		INNER JOIN workorders
		ON woitems.wo=workorders.wo
		AND woitems.wo=worequirements.wo
		INNER JOIN locationusers ON locationusers.loccode=workorders.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1
		WHERE  worequirements.stockid='" . $StockID . "'
		AND workorders.closed=0";
$ErrMsg = _('The workorder component demand for this product cannot be retrieved because');
$DemandResult = DB_query($sql, $db, $ErrMsg);
if (DB_num_rows($DemandResult) == 1) {
	$DemandRow = DB_fetch_row($DemandResult);
	$Demand+= $DemandRow[0];
}

With something like this. (Not tested)
$sql="SELECT SUM(qtypu * (woitems.qtyreqd - woitems.qtyrecd)) as reqqty,
			SUM( - qty ) as issqty
		FROM worequirements INNER JOIN woitems
		ON woitems.wo=worequirements.wo
		AND woitems.stockid = worequirements.parentstockid
		INNER JOIN workorders on workorders.wo=woitems.wo
		LEFT OUTER JOIN stockmoves ON stockmoves.type =28
		AND reference=woitems.wo
		AND stockmoves.stockid='" . $StockID."'
		WHERE workorders.closed=0
		AND worequirements.stockid='" . $StockID."'";

$ErrMsg = _('The order details for this product cannot be retrieved because');
$RequirmentsResult = DB_query($sql,$db,$ErrMsg);
$WoResult = DB_query($sql,$db,$ErrMsg);
$WoRow = DB_fetch_row($WoResult);
if ($WoRow[0]!=null){
	$ReqQty =  floatval($WoRow[0]);
} else {
	$ReqQty = 0;
}
if ($WoRow[1]!=null){
	$IssQty =  floatval($WoRow[1]);
} else {
	$IssQty = 0;
}
$Demand+= ($ReqQty - $IssQty); 


Best Regards,
Andrew Galuski


-----Original Message-----
From: rfthomas [mailto:rf...@as...] 
Sent: Thursday, March 10, 2016 11:30 AM
To: web...@li...
Subject: Re: [WebERP-developers] Completed Work Order deletes unused serial inventory

To provide further detail:

Work Orders do not properly deal with serialized inventory

To demonstrate the problem create the following two inventory items:

TEST_SERIAL – purchased/controlled/serial number TEST_SERIAL_M – manufactured/controlled/serial number

Create a BOM for TEST_SERIAL_M with one entity:

TEST_SERIAL QTY 1, Not Auto Issued

Add 7 of TEST_SERIAL to inventory, S/N 1, 2, …, 7

Create a Work Order to manufacture 5 of TEST_SERIAL_M.

Issue 5 of TEST_SERIAL to the newly created work order, using serial nos. 1, 2, 3, 4, and 5

Receive 2 of TEST_SERIAL_M where the received items have serial nos. 1 and 2

When one looks at inventory for TEST_SERIAL: quantity on hand = 2, quantity demand 3, available -1.  This is the first error in inventory: The demand is
0 since 5 parts have already been issued to the work order to manufacture TEST_SERIAL_M and there are 2 parts available.  When one examines serial numbers there are serial numbers 6 and 7.

Inventory movements show:
Stock Adjustment +7 New quantity 7
Work Order Issue -7 New quantity 2

The receive function does not force entry of the serial numbers of TEST_SERIAL when receiving TEST_SERIAL_M.  This is incorrect since the reason serial numbers as well as batch/lot numbers is to provide component traceability.  The receive function must properly allocated the material and make a proper move notification.  Such never occurs.

After the work order is closed, not having consumed all of the issued items, unused items are never returned to inventory.  Three unused serial number items are deleted from the system with no trace.

There should be 5 of TEST_SERIAL in inventory and 2 in TEST_SERIAL_M parts in inventory.  If the 2 TEST_SERIAL parts in TEST_SERIAL_M parts need to be tracked back, reports could be written to generate the migration of the part.

In the US, there are regulations that require traceability of components. 
The FAA (Federal Aviation Administration), DOD (Department of Defense), FDA (Food and Drug Administration), among others require such.  An example are components going into a jet aircraft engine:  Each piece of raw material is tracked by Foundry/lot, then serialized when cut into blanks, and traced throughout manufacture to the completed rotor and engine.  One would expect that such is also required by other countries.
Any thoughts/suggestions on what can be done to meet these requirements and correct the inventory errors?




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Completed-Work-Order-deletes-unused-serial-inventory-tp4658530p4658553.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Completed Work Order deletes unused serial inventory

[rfthomas <rf...@as...>]

To provide further detail:

Work Orders do not properly deal with serialized inventory

To demonstrate the problem create the following two inventory items:

TEST_SERIAL – purchased/controlled/serial number
TEST_SERIAL_M – manufactured/controlled/serial number

Create a BOM for TEST_SERIAL_M with one entity:

TEST_SERIAL QTY 1, Not Auto Issued

Add 7 of TEST_SERIAL to inventory, S/N 1, 2, …, 7

Create a Work Order to manufacture 5 of TEST_SERIAL_M.

Issue 5 of TEST_SERIAL to the newly created work order, using serial nos. 1,
2, 3, 4, and 5

Receive 2 of TEST_SERIAL_M where the received items have serial nos. 1 and 2

When one looks at inventory for TEST_SERIAL: quantity on hand = 2, quantity
demand 3, available -1.  This is the first error in inventory: The demand is
0 since 5 parts have already been issued to the work order to manufacture
TEST_SERIAL_M and there are 2 parts available.  When one examines serial
numbers there are serial numbers 6 and 7.

Inventory movements show:
Stock Adjustment +7 New quantity 7
Work Order Issue -7 New quantity 2

The receive function does not force entry of the serial numbers of
TEST_SERIAL when receiving TEST_SERIAL_M.  This is incorrect since the
reason serial numbers as well as batch/lot numbers is to provide component
traceability.  The receive function must properly allocated the material and
make a proper move notification.  Such never occurs.

After the work order is closed, not having consumed all of the issued items,
unused items are never returned to inventory.  Three unused serial number
items are deleted from the system with no trace.

There should be 5 of TEST_SERIAL in inventory and 2 in TEST_SERIAL_M parts
in inventory.  If the 2 TEST_SERIAL parts in TEST_SERIAL_M parts need to be
tracked back, reports could be written to generate the migration of the
part.

In the US, there are regulations that require traceability of components. 
The FAA (Federal Aviation Administration), DOD (Department of Defense), FDA
(Food and Drug Administration), among others require such.  An example are
components going into a jet aircraft engine:  Each piece of raw material is
tracked by Foundry/lot, then serialized when cut into blanks, and traced
throughout manufacture to the completed rotor and engine.  One would expect
that such is also required by other countries.
Any thoughts/suggestions on what can be done to meet these requirements and
correct the inventory errors?




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Completed-Work-Order-deletes-unused-serial-inventory-tp4658530p4658553.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Error with new GLPosting.inc when addding a GL account

[ExsonQu <hex...@gm...>]

*Hi, Richard,*

                Just check it and found it's a typo which typed account code
instead of accountcode. Sorry for the mistake. 

                Please check if this problem fixed and if there are any
other problem. 

                Thanks and best regards!

                Exson
                 GLPostings.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658550/GLPostings.inc>  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-with-new-GLPosting-inc-when-addding-a-GL-account-tp4658546p4658550.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Error with new GLPosting.inc when addding a GL account

[ExsonQu <hex...@gm...>]

*Hi, Richard,*

               Thank you for your feedback.  I'll check what goes wrong. 
               
               Thanks and best regards!

               Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-with-new-GLPosting-inc-when-addding-a-GL-account-tp4658546p4658549.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Error with new GLPosting.inc when addding a GL account

[Pak R. <pak...@gm...>]

Hi Exson:

For business reasons, I just had to create a new GL account and record a
transaction against it. When I tried to see the balance sheet afterwards I
get this error:

*Database Error 1064* : Failed to retrieve new account code and periods
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'code IS NULL
ORDER BY accountcode,periodno' at line 6
*Database SQL Failure* : The SQL that failed was
SELECT chartmaster.accountcode,periods.periodno FROM (chartmaster CROSS
JOIN periods) LEFT JOIN chartdetails ON
chartmaster.accountcode=chartdetails.accountcode AND
periods.periodno=chartdetails.period WHERE (periods.periodno BETWEEN '-14'
AND '106') AND chartdetails.account code IS NULL ORDER BY
accountcode,periodno

I think it's related to the new GLPosting.inc file, as it's the only
updated file we played with lately. I reverted the GLPosting.inc file to
the previous version and worked OK again, so seems like related to the new
GLPosting.inc

Could you please check it out?

Regards,
Ricard

Re: [WebERP-developers] Form Designer errors/warnings

[gilberto d. s. a. <gs...@gm...>]

hi. i will run tests on our environment (pt-br). thanks.

2016-03-07 17:09 GMT-03:00 Andrew Galuski <aga...@re...>:

> The problem is with how this screen tries to use the Language function for
> translation.
> When it outputs 'translated' text using _($FormDesign['name'])
> $FormDesign['name'] is not a string but an XML Object
> Var_dump($FormDesign['name'] yields
>
> object(SimpleXMLElement)[2]
>   string 'FG Label' (length=8)
>
> If you cast it as a string using _((string)$FormDesign['name']) it works.
> If you go through the code everywhere the can do a search and replace on
> _($FormDesign[' and change it to _((string)$FormDesign['  same with
> _($subkey[' and _($key['
>
> I attached a copy that works for me
>
>
> Best Regards,
> Andrew Galuski
> ResMart LLC.
> 817.615.3206 (Office)
> 817.821.0544 (Cell)
> www.resmart.com
>
>
> -----Original Message-----
> From: rfthomas [mailto:rf...@as...]
> Sent: Monday, March 07, 2016 12:22 PM
> To: web...@li...
> Subject: [WebERP-developers] Form Designer errors/warnings
>
> When we attempt use the Form Designer, the following errors are displayed
> in many places ion the screen:
>
> Warning: array_key_exists(): The first argument should be either a string
> or an integer in /ast$www/weberp/includes/php-gettext/gettext.php on line
> 258
>
> This number of times this is displayed makes the code impossible to use.
>
> Bob Thomas
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Form-Designer-errors-warnings-tp4658541.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with Intel Data Analytics
> Acceleration Library.
> Click to learn more.
> http://makebettercode.com/inteldaal-eval
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://makebettercode.com/inteldaal-eval
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Form Designer errors/warnings

[Andrew G. <aga...@re...>]

The problem is with how this screen tries to use the Language function for translation.
When it outputs 'translated' text using _($FormDesign['name']) $FormDesign['name'] is not a string but an XML Object
Var_dump($FormDesign['name'] yields

object(SimpleXMLElement)[2]
  string 'FG Label' (length=8)

If you cast it as a string using _((string)$FormDesign['name']) it works.
If you go through the code everywhere the can do a search and replace on _($FormDesign[' and change it to _((string)$FormDesign['  same with _($subkey[' and _($key['

I attached a copy that works for me


Best Regards,
Andrew Galuski
ResMart LLC.
817.615.3206 (Office)
817.821.0544 (Cell)
www.resmart.com


-----Original Message-----
From: rfthomas [mailto:rf...@as...] 
Sent: Monday, March 07, 2016 12:22 PM
To: web...@li...
Subject: [WebERP-developers] Form Designer errors/warnings

When we attempt use the Form Designer, the following errors are displayed in many places ion the screen:

Warning: array_key_exists(): The first argument should be either a string or an integer in /ast$www/weberp/includes/php-gettext/gettext.php on line 258

This number of times this is displayed makes the code impossible to use.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Form-Designer-errors-warnings-tp4658541.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library.
Click to learn more.
http://makebettercode.com/inteldaal-eval
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] Form Designer errors/warnings

[rfthomas <rf...@as...>]

When we attempt use the Form Designer, the following errors are displayed in
many places ion the screen:

Warning: array_key_exists(): The first argument should be either a string or
an integer in /ast$www/weberp/includes/php-gettext/gettext.php on line 258

This number of times this is displayed makes the code impossible to use.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Form-Designer-errors-warnings-tp4658541.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Add a direct credit/debit note feature to webERP

[ExsonQu <hex...@gm...>]

*Hi, Phil,*
           Thank you for your reply. 
            It is a smart way! 
            Is it more like a workaround? 
            Thanks and best regards!

            Exson
               
           



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532p4658538.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Add a direct credit/debit note feature to webERP

[Phil D. <ph...@lo...>]

Say you want to create a marketing give away code. You create a Z stock 
category - say ZM the stock GL codes do not matter as there will never 
be any stock.
Then define the sales GL posting to marketing and advertising and add a 
dummy item of that stock category. Now produce a credit note for that 
item...

Main Menu->Receivables->Create Credit note

Select customer

Select the dummy item etc....

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 03/03/16 16:15, ExsonQu wrote:
> *Hi, Phil,*
>
>             Thank you for your reply.
>             Is there really a feature to do this? Would you like to tell me
> how to do this?
>
>             Thanks and best regards!
>
>             Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532p4658536.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Add a direct credit/debit note feature to webERP

[ExsonQu <hex...@gm...>]

*Hi, Phil,*

           Thank you for your reply. 
           Is there really a feature to do this? Would you like to tell me
how to do this?

           Thanks and best regards!

           Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532p4658536.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Add a direct credit/debit note feature to webERP

[<ph...@lo...>]

We can already create a GL credit note - I'm thinking this might not be 
necessary....
Phil

On 2016-03-02 18:26, ExsonQu wrote:
> *Hi, Phil,*
> 
>             Thank you for your reply.
> 
>             The GL should be updated as:
> 
>                                   Dr Account selected by users
>                                      Cr Account Receivable account
> 
> 
>               And currently, I have not consider the tax part.
>              Thanks and best regards!
> 
>              Exson
> 
> 
> 
> 
> 
> 
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532p4658534.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Add a direct credit/debit note feature to webERP

[ExsonQu <hex...@gm...>]

*Hi, Phil,*
              
            Thank you for your reply.

            The GL should be updated as:

                                  Dr Account selected by users
                                     Cr Account Receivable account
                
                      
              And currently, I have not consider the tax part. 
             Thanks and best regards!

             Exson
             
                                    
                            



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532p4658534.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Add a direct credit/debit note feature to webERP

[Phil D. <ph...@lo...>]

How does the GL get updated?
Is tax handled on these too?

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 02/03/16 20:15, ExsonQu wrote:
> *Dear all,*
>
>              I've created a feature to credit small amount (the amount is set
> up in a script) to a specific customer with respective account directly.
>              It seems a general requirements for most of these users. For
> instance, users can write off those small amount for customer. Or they can
> debit their customers for some service which has no benefit.
>              I'm wondering if we can merge this feature to webERP?
>              The same requirements can be completed for suppliers.
>              Thanks and best regards!
>
>              Exson
>             
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Add a direct credit/debit note feature to webERP

[ExsonQu <hex...@gm...>]

*Dear all,*

            I've created a feature to credit small amount (the amount is set
up in a script) to a specific customer with respective account directly. 
            It seems a general requirements for most of these users. For
instance, users can write off those small amount for customer. Or they can
debit their customers for some service which has no benefit. 
            I'm wondering if we can merge this feature to webERP?
            The same requirements can be completed for suppliers. 
            Thanks and best regards!

            Exson  
           



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Add-a-direct-credit-debit-note-feature-to-webERP-tp4658532.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Completed Work Order deletes unused serial inventory

[rfthomas <rf...@as...>]

We have a work order and associated BOM that includes on serial numbered
item.  The work order call for 100 parts to be produced.  Only 83 were
produced (received).  The serial numbers of the BOM item (issued to the work
order) were consummed upon item receipt.  There were 17 serial number items
remaining.  The work was closed and instead of returning the issued serial
number items thay have disappeared.

There is no record in the Audit Trail showing any action for the part code
or serial number when teh Work Order is closed.  There is nothing in the
Serial Number History after the serial numbered item is issued to the work
order.

When a work order is closed, the unused issued items should be returned to
inventory, not just disappear.  

There are no reports available to readily trace what has happened.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Completed-Work-Order-deletes-unused-serial-inventory-tp4658530.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] (no subject)

[gilberto d. s. a. <gs...@gm...>]

Hi. and make sure that you visit [1] for proof-of-concept, testes and
manual that show lots of details.
Regards.

[1] http://www.weberp.org/weberp/

2016-02-24 17:11 GMT-03:00 ngani faith <nga...@gm...>:

> Hi everybody,
> my name is Faith , i am new to webERP development and i wish to start
> actively developing on webERP. Please can anybody help me with any links or
> any indications on how to start to understanding the architecture of the
> system. I would be pleased if someone could help put me on the right track
> as soon as possible.
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] (no subject)

[<ph...@lo...>]

Whoops sorry for the double up...
Phil

On 2016-02-24 14:18, ExsonQu wrote:
> *Hi,*
> 
>             You can get lots of data here:
>               http://www.weberp.org/wiki/WeberpDevelopment
> <http://www.weberp.org/wiki/WeberpDevelopment>
>             Thanks and best regards!
> 
>             Exson
> 
> 
> 

Re: [WebERP-developers] (no subject)

[<ph...@lo...>]

Hello Faith,

Try starting with these links and see where they lead you....

http://www.weberp.org/Development.html

http://www.weberp.org/wiki/WeberpDevelopment

a fair bit of reading - the code is the ultimate developers manual of 
course.

Phil

On 2016-02-24 13:11, ngani faith wrote:
> Hi everybody,
> my name is Faith , i am new to webERP development and i wish to start
> actively developing on webERP. Please can anybody help me with any
> links or any indications on how to start to understanding the
> architecture of the system. I would be pleased if someone could help
> put me on the right track as soon as possible.
> 
> 
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> 
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] (no subject)

[ExsonQu <hex...@gm...>]

*Hi,*

            You can get lots of data here: 
              http://www.weberp.org/wiki/WeberpDevelopment
<http://www.weberp.org/wiki/WeberpDevelopment>  
            Thanks and best regards!

            Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/no-subject-tp4658521p4658522.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] (no subject)

[ngani f. <nga...@gm...>]

Hi everybody,
my name is Faith , i am new to webERP development and i wish to start
actively developing on webERP. Please can anybody help me with any links or
any indications on how to start to understanding the architecture of the
system. I would be pleased if someone could help put me on the right track
as soon as possible.

Re: [WebERP-developers] Issue with GLPostings.inc

[Pak R. <pak...@gm...>]

Hi Exson:

It's just the opposite way. It's me (and for sure all of other developers)
thanking you for all your dedication and cooperation :-)

Regards,
Ricard

2016-02-24 8:41 GMT+08:00 ExsonQu <hex...@gm...>:

> *Hi, Richard,*
>
>               Thank you very much for your test!
>
>               Best regards!
>
>               Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Issue-with-GLPostings-inc-tp4658512p4658518.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] The wrong balance carried forward has been fixed

[ExsonQu <hex...@gm...>]

*Hi, David,*

                Richard found that the bfwd amount initiation still not
correct. Thank you very much for his finding and test. I've revised the
GLPosting.inc file to correct this problem. 
                You can get the new version from trunk or the attached file. 
                Sorry for the mistake and any inconvenience caused!

                Thanks and best regards!

                Exson
               GLPostings.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658519/GLPostings.inc>  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/The-wrong-balance-carried-forward-has-been-fixed-tp4658479p4658519.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Issue with GLPostings.inc

[ExsonQu <hex...@gm...>]

*Hi, Richard,*

              Thank you very much for your test!

              Best regards!
              
              Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Issue-with-GLPostings-inc-tp4658512p4658518.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.