Search options (Page 2 of 5)

Thanks @apmuthu. I wasn't sure if there was a better way to handle this.

Try this one:

https://sourceforge.net/projects/frontaccounting/

Thanks for the reply, apmuthu, but this does not seem to work. I tried your suggestion before starting this post and it did not work.

While I don't understand all of the code for obtaining the next number, I find this after I start a new work order when I have the Transaction References set to 3 for prefix followed by {YY}{01}{MM}:

SELECT MAX(CAST(SUBSTR(wo_ref, 4,LENGTH(wo_ref)-5) AS UNSIGNED)) FROM `workorders` tbl
                    LEFT JOIN voided v ON tbl.`id`=v.id AND v.type='26' WHERE ISNULL(v.id) AND `wo_ref` REGEXP '^319[0-9]*12$'

  It looks like it is looking in the workorders table to extract the next number and the resulting number is 3198612

  When I change the Transaction Reference to 3 {YY}{01}, I get this:

SELECT MAX(CAST(SUBSTR(wo_ref, 4,LENGTH(wo_ref)-3) AS UNSIGNED)) FROM `workorders` tbl
                    LEFT JOIN voided v ON tbl.`id`=v.id AND v.type='26' WHERE ISNULL(v.id) AND `wo_ref` REGEXP '^319[0-9]*$'

  The result is 3191287. I was hoping to get 31987.

In case someone else runs into the issue of becoming logged out without requesting it, I edited my php.ini file and changed session.gc_maxlifetime = 1440 to a higher value that works better in our environment. I found this line at approximately 3/4 the way down from the beginning. Hope this helps.

What is best practice to perform physical inventory update to QOH? We usually like to count all stock once a year, so we know total count is accurate.

I think I understand Retail/Wholesale pricing: Right now my items all have a Retail price setup in Sales Pricing as the majority of my customers are retail-type. So if I have the Base for auto price calculations set to Retail, then Sales Types will be working off of the Retail Sales Price set for the item.

  The only way I can get cost plus to work is to remove all Sales Pricing for the items. Then, when I place a percentage in the Add Price from Std Cost under Company, I get the desired cost-plus in new sales order screen.

  But I need both Retail and cost plus. The retail needs to stay somewhat stable and I will adjust this periodically when cost rise enough to warrant it. I believe my majority retail customers expect this. The selling margin would then change as the cost moves around due to a fixed retail price.

  I also have a few customers that will purchase these same items, but we agree to sell these to them at a percentage above cost. This price can fluctuate frequently as the cost changes and these customers realize this. I don't want to maintain the cost-plus selling price separately. If I change the cost, or if the cost changes due to manufacturing and averages, I want the next order placed with a cost-plus customer to reflect the updated cost-plus price.

  I have tried using no base pricing, but did not seem to help. Is there a way to have both an established static retail price set in Sales Pricing for an item and also have access to a dynamically set cost-plus price??

  Thanks,

Paul

I must need to think about this more.

   One of my main bank statements runs from the 16th of last month to the 15th of the this month. If I write a $50 check on the 10th of this month, it probably won't make it on the statement closing on the 15th of this, but that check will be posted to my bank account's register, reducing the balance by $50. My current balance sheet reflects the $50 out. If I take my balance sheet amounts and use those for the opening balances in FA, my next bank statement will have a $50 check that won't be shown in FA's bank statement account. I'm missing something (again).

Great idea. I'll have to keep that tip in mind. The way I attempted to check was to turn on FA's logging to screen and looked for the update lines - I thought I may have missed one or more the way I did it.

It also appears that when changing an items Item Adjustment Account in Maintenance-> Items, that only stock_master table is updated with the account number and not any other table. Is this observation accurate?