But not really. Trying to approve the inventory report leads to a series
of errors due to lack of permissions. So I had to grant
SELECT,INSERT,UPDATE,DELETE to
inventory_report
inventory_report_line
order_sum
invoice_sum
to an appropriate role. If there is a UI possibility to do so, I'd like
Den 02-05-2017 kl. 13:29 skrev Chris Travers:
Inventory reports are intended to be subject to separation of duties.
You have to search for the report, view it, and approve it. The
report snapshots onhand at the time inventory was entered so the
adjustment is preserved over time.
Thanks.
Hi;
On Tue, May 2, 2017 at 12:27 PM, Kaare Rasmussen wrote:
> Hi
>
> We'd like to conduct an inventory of our stock. I see two options,
> Import and Enter inventory.
>
> The first, importing inventory asks for some parameters I don't
> understand. AR and AP accounts are dropdowns w/o any selecta
>
> Further to what Chris has said, if by 'start from scratch' you mean insert
> everything again, I see no reason why you would do that. Just insert
> *correcting* records with their appropriate dates.
>
-
This SF.net email is
Further to what Chris has said, if by 'start from scratch' you mean insert
everything again, I see no reason why you would that. Just insert records
with their appropriate dates.
-
This SF.net email is sponsored by: Microsoft
D
On 9/27/07, Charley Tiggs <[EMAIL PROTECTED]> wrote:
>
> I have several questions regarding LSMB and handling of COGS and
> inventory.
>
> I now know that, in order for COGS to be handled correctly, when I
> initially set up the application, I must create AP invoices to insert
> the AP invoices and
The last 2 queryes that I posted were proven to be wrong after a little
testing.
I've just looked on Ed's queryes.
It can't last 2 hours on a database like you described(it takes a few
seconds on my db). Maybe you nedd a "vacuum analyze" and an update to
max_fsm_pages - I had the same problem
This should be the query that will show the quantities also:
SELECT p.id, p.description, p.partnumber, sum(i1.qty), sum(i.qty),
sum(i.sellprice*-i.qty), sum(acc.amount),
sum(i.sellprice*-i.qty)-sum(acc.amount)
FROM invoice i
JOIN ap a ON (a.id=i.trans_id AND a.transdate<='2007-7-15')
JOIN part
I made a query that takes 4 seconds for a database with 3689 ap invoices
and 68834 ar invoices.
My test system is a dual xeon 2.2Gh with 2Mega RAM.
It requires 2 indexes.
CREATE INDEX parts_inventory_accno_id ON parts (inventory_accno_id);
CREATE INDEX acc_trans_invoice_id ON acc_trans (invoice_
On Sat, 14 Jul 2007, Charley Tiggs wrote:
> One of my clients just did inventory the past two days and we needed
> this feature. I ended up doing what Ed did.
>
> Ed W wrote:
> > I wrote a small query to calculate the inventory and then just exported
> > it to a spreadsheet. However would be usef
One of my clients just did inventory the past two days and we needed
this feature. I ended up doing what Ed did.
Charley
Ed W wrote:
> Victor Sterpu wrote:
>> I'm want to make a inventory function that to print the inventory at a
>> specific date.
>> The inventory must show the quantities and
Victor Sterpu wrote:
> I'm want to make a inventory function that to print the inventory at a
> specific date.
> The inventory must show the quantities and also the value of the
> inventory account for each group of products.
> So it will show the quantities and the values of the ramaining items.
Chris Travers wrote:
On 7/13/07, Victor Sterpu <[EMAIL PROTECTED]> wrote:
I'm want to make a inventory function that to print the inventory at a
specific date.
The inventory must show the quantities and also the value of the
inventory account for each group of products.
So it will show the qu
On 7/13/07, Victor Sterpu <[EMAIL PROTECTED]> wrote:
> I'm want to make a inventory function that to print the inventory at a
> specific date.
> The inventory must show the quantities and also the value of the
> inventory account for each group of products.
> So it will show the quantities and the
14 matches
Mail list logo
