Search options (Page 24 of 42)

Hi Derek,

I wish I could have said big yes, but unfortunately it's not. However, I'm truly grateful for your kind efforts of help... Always...

I'm not sure if you have checked out my latest sample project named "Save as new record Test.zip " on post #3. There, all those show/hide, enable/disable events quite close to what I'm trying to achieve with the exception of hiding some Invoice Type combo items.
1. Hiding when adding new record. Since we can only issue refund for something received, I wanted to hide "Sale", "Sale Refund" and "Purchase Refund" combo items when we are adding a new purchase invoice. Smilarly, hiding "Purchase", "Sale Refund" and "Purchase Refund" combo items when we are adding a new sale invoice.
2. When user clicks on Edit selected Purchase Invoice, Invoice Type combo item "Sale Refund" should be hidden preventing user saving it as a sale refund by mistake.
3. When user clicks on Edit selected Sale Invoice, Invoice Type combo item "Purchase Refund" should be hidden preventing user saving it as a purchase refund by mistake.

Key point is when issuing a refund against an invoice (fully or partially) refund should be saved as a new record, not overwriting existing record as it currently does. Please see images (1,2,3 and 4) on the post #3. Hence the title of the post most important part is to achieve saving existing record as different/new record which I have no idea how to do it with using same table and form. Perhaps post title should have been Saving existing record as an another record.

Required overlying objects on the form can be done later on as needed. It's easier to manage them during work/test phase. I left Refund numbers panels separate atm but they will be overlaid once all working. I usually do cosmetics on later stages of the project .

Hi EHW,

Looks like I have overlooked some items.

Adding sale or refund inv works fine.
However, converting (changing) sele inv to refund inv and refund inv to sale inv using DB/CR combo is not.

1. Entered sale  then changed DC/CR combo to refund. Discount and Deliv Cost fields values is not converted to minus:

1. Entered refund then changed DC/CR combo to sale. Discount and Deliv Cost fields values is not converted to positive numbers:

I have tried to move your code under DBCR combo on change with else but didn't work:

procedure frmSalesInv_cbSaleInvDBCR_OnChange (Sender: string); // SALE or REFUND
begin
  If (frmSalesInv.cbSaleInvDBCR.dbItemID = 2) and (frmSalesInv.edSalesInvDelivCost.Value > 0) then
      begin
      frmSalesInv.edSalesInvDelivCost.Value := 0 - frmSalesInv.edSalesInvDelivCost.Value;
      CalculateTotal;
      end else
      begin
      frmSalesInv.cbSaleInvDBCR.dbItemID := 1;
      frmSalesInv.edSalesInvDelivCost.Value;
      CalculateTotal;
      end;

  If (frmSalesInv.cbSaleInvDBCR.dbItemID = 2) and (frmSalesInv.edSalesInvDiscount.Value > 0) then
      begin
      frmSalesInv.edSalesInvDiscount.Value := 0 - frmSalesInv.edSalesInvDiscount.value;
      CalculateTotal;
      end else
      frmSalesInv.cbSaleInvDBCR.dbItemID := 1;
      frmSalesInv.edSalesInvDiscount.Value;
      CalculateTotal;
end;

Sorted calc fields.. but cannot get Discount and Deliv Cost values displayed as minus (-) values.

tried following but no luck

frmSalesInv.edSalesInvDelivCost.Value := - (frmSalesInv.edSalesInvDelivCost.Value);
frmSalesInv.edSalesInvDiscount.value := - (frmSalesInv.edSalesInvDiscount.value);

Hi Derek,
Nice one...  Truly appreciated..........
Adding a message for selecting actual item is very thoughtful of you.

Hi JB,
Thanks for the info.............

Still couldn't resolve clearing tGrid rows issue.
Perhaps I couldn't explain my issue clearly on my first post above. This time I try with the image below:

Hi EHW,

At my end I cannot get checkboxes checked on running app. Please see image below as ref. Most likely I'm missing something?

On save front, I really don't want auto save. Save should be done when user wants to save by clicking on save button as they may be doing some test pw generations and they wouldn't want to save every test etc. Please don't misunderstand me. I'm not complaining. In fact I'm truly grateful for your all kind help. Would it be possible within your limited time to take of auto-save please?
So record is not saved after clicking on "generate passwords" button but after user clicks on "save" button - in this case button3.