Script

[ivank]

Hello

I have a simple relationship between fields in a portal , line item unit Enter (number of items in a warehouse -enter which doesn't change its value once entered, line item  unit out of storage Exit (number of items leaving the warehouse) and amount in stock field, which is a calculatuion. line items in  minus line items out.

The relationship I created using set field on the invoice page   

 

 

Set variable [$$Amount in stock,Value Line Items:Enter-Line Items : Exit]

Set Fiedl[Line Items Amount in Stock:Value $$Amount in Stock]

Comit records no dialog

 

and

 

 

Set variable [$$EnterExit,Value Line Items:Enter-Line Items : Exit]

Set Fiedl[Line Items Amount in Stock::Value $$EnterExit]

Set Fiedl[Related Product Amount in Stock::Value $$EnterExit]

Set Fiedl[Related Product Last Enter::Value $$EnterExit]

Set Fiedl[Related Product Last Exit::Value $$EnterExit]

Comit records no dialog

 

so it shows the values on products page related to the product which is presently handled (exitin the warehouse)

 

Now on the invoice page if I am enterring values in to the exit field more than once untill all my stock is out,the valuse is alwaays substracting from  the existing value for products in storage.

 

to be more specific

 

products in                                product out                       Amount in stock 

300                                       -            200                   =                    100

this value never changes

it is what I have had             -           20                      =          here value should be 80

                                                                                 =            instead is 280

 

 

Do I make myself clear??

 

 

How do I write the script () to define that each consecutive enter should substract from what was lef in stock not from the beginign value of the products in?

 

thanks

[LaRetta]

Hi!  Welcome to FMForums!

 

I have reviewed your post a few times and I am still unclear on what you need.  Can you create an empty clone of your file (File > Save As > clone no records) and then zip it and attach it?  Then create a single dummy record for a customer, invoice and a few lineitems and provide the layout name (if not obvious) and exactly which fields are not producing the totals you wish?

[ivank]

I made a clone and i want to share it with you but in this reply I cant find the attach file action is there an email, adress that you can share so I can send it via mail, I lost all day playing with this file , and I amg etting streesed , with no solution

 

what II wanted to say is 

at the begining I have product that are in the warehouse and then  another field representing the products leaving the warehouse, which can happen again and again until all the products are out

 

the amount in stock is a result of a calcualtion  products in (they are always trhe same ones they are in thats it for example 2800) the product out are entered several times, , for example today 1860, tomorow 100 , day after 2900,

 

amount in stock will always shoe  A-B = C

 instead of

A-B=C

A-B1=C1

A-B2 =C2 etc

how am I doing expalining , yes on the same line

[Lee Smith]

If you tried to attach a file, it didn't make it. The process is rather easy, if you follow these steps.

Step 1
Find the file on your hard drive, and zip it.

Step 2
Do not use the Quick Reply, BUT instead, choose the More Reply Option 

Step 3

Click on Attached Files and this will take you to your hard drive to locate your file that you want to attach and that you previously zipped. Select the file, and then click Attach This File, and then click Add Reply.

If you should have a problem write me a private me

[ivank]

Here is the file

 

 

Here is the file I was talking about

E-Lager Clone Clone.fp7.zip

Edited November 19, 2012 by Lee Smith
attached file

[LaRetta]

account?  password?

[Lee Smith]

LOL, and the hits just keep on coming.

[ivank]

Account Admin

Password 123

 

 

I solved it in the meantime but if you want to play with the file please go ahead

it was rather simple  at the end

 LOL

[ivank]

It seems that last time i posted a topic I worked out the assignment , I ll try again,

 

A column on my table is assigned values that represent products leaving the warehouse,

a table has two sheets detail one and customs number sheet.

I have a field on a Customs sheet should show  a result totaling  products leaving the warehouse.  Instead of totaling the products on customs sheet

i get the values for each column row that represent quantity out.

 

what i want is separate total values in a field , each time a total  is needed. 

 

[ivank]

is it possible to set field  and related to the sales date,

 

 

if( todays date) show result sum of related field?

 

thank you

[ivank]

seems pretty  complicated

 

if i input values in in cellsthat represent quantity out of storage  my user want' s to set  date field when this transaction was due and also show in a new cell total of those products on that date

 

and then next date, and next etc...

[ivank]

The problem there is this---I need a cell to calculate two values items out of storage subtracted from items in storage  

Ok

I get the result sum value of all those products in two ways

Either  list of all values that has been subtracted in a portal, or total value in one cell outside of portal..

 

 

If I input a field that is a total value in a portal it produces the total in every cell line in that row(where I was showing items subtracted form product in warehouse) what is needed is each cell in that row to show different totals-do you understand each time we input all the values out of storage.

 

 

If I have  products going out today and product going out tomorrow and next day, those are three different totals  in three dates (there is a date field right next to total field so my user  can identify which amount was there on which day) ,

 

 

 

If my whole cell-row shows the first total in  cells I got a problem, or next total  again in whole cell-row my user  cant identify-connect two different dates with two total products. Or god forbid more dates more total which happens when we need to organise data.

 

 

So how do we design –write a script which would tell the cell row, show me total when needed then go to next cell in a same row and show new total , exit after last. J