FrontAccounting forum — Item and Inventory

Re: Item and Inventory

null@example.com (apmuthu) — Wed, 12 Mar 2014 15:19:07 +0000

It is "FROM" instead of "FORM" in the SQL.

Re: Item and Inventory

null@example.com (mfaa98) — Sat, 08 Mar 2014 15:36:06 +0000

Hi saifmalik,
is it possible that you forget to add the dot before and after TB_PREF variable?

'SELECT * FORM ".TB_PREF."sales_order_details'

Re: Item and Inventory

null@example.com (saifmalik) — Fri, 07 Mar 2014 06:17:22 +0000

HI
I have created a page in sales folder and write down some queries its working fine. Because i have used only table name like
"SELECT * FORM 0_sales_order_details"
But when i login with the new company name these queries did not work. I have tried to use "TB_PREF" but its not working. Because I don't know to get the value of "TB_PREF" on my custom created page.
'SELECT * FORM "TB_PREF"sales_order_details' But when i use this one its not working.
Please help me.
Thnx

Re: Item and Inventory

null@example.com (apmuthu) — Wed, 12 Feb 2014 05:54:23 +0000

Make 3 separate FA installs in the same machine and create editable 1:1 views from a common db into each FA instance's db for those tables that need to be the same across all all FAs.

Re: Item and Inventory

null@example.com (joe) — Fri, 31 Jan 2014 09:29:31 +0000

This is not possible in existing core.You can either make an extension or change the code.

/Joe

Re: Item and Inventory

null@example.com (saifmalik) — Fri, 31 Jan 2014 04:59:32 +0000

DEAR
Sir
I need your help.Please guide me.
I have created 3 inventory location.
then I have created 3 POS NAme
Then I have created 3 user and assign them different different User's POS:
My requirement is that a single user can see its own inventory location status and work on it.
User should not see all inventory location status
Please guide me
THnx

Re: Item and Inventory

null@example.com (saifmalik) — Fri, 31 Jan 2014 04:47:51 +0000

THnx Joe
But I am facing still problem.

I have created a Point of Sale Name: with the name of pop ans assing them POS location:that is CBT

when i create a user with the name of saif and assign it User's POS: pop

But when i login with the new username saif
its showing all inventory item status...My requirement is that it should show only CBT status
not all items status

Re: Item and Inventory

null@example.com (joe) — Thu, 30 Jan 2014 07:31:48 +0000

You cannot assign a user to a specific item. Consider using dimensions and call it a user name and assign it to the item.

You can also put a location to a POS which you can put on every user.

You may test for yourself on the Training Co.

/Joe

Item and Inventory

null@example.com (saifmalik) — Thu, 30 Jan 2014 07:13:55 +0000

Dear Sir
I want to assign single store to a single store.
My requirement is to create multiple inventory location and assign each inventory to a specific user.
How to do it....?
Thnx