Newbie advice

Tue Aug 24 12:23:48 PDT 2021

Ok.  The following is the code that I think is the culprit as it is handling
the reversal of an invoice and that is where it blew up.  It is in a piece
of code called REVERSIT.PRC that is called from GFSALES/KEYR.prc code. That
code handles the user entering R while looking at an invoice to
reverse/refund the amount.     The code with line numbers is as follows:

809 INVHIST:'inventory history for items that are not sets::
810 ::lookup his = gfinvhis  r=free  -e:
811 :                                'item code:his(1)=xx:
812 :                                'today's date:his(2)=orddate:
813 :                                'time:his(3)=@tm:
814 :                                'action (sold):his(4)="reversed sale on
inv. #"<10:
815 :                                'quantity:his(5)=qt:
816 ::his(6)=inv(16):
817 ::inv(7)=10:
818 ::write his:
819 ::return:

It appears we are getting a free record from the inventory hist table and
fill it in with some info and then on line 816 filling his(6) with a value
from inv(16).  I'm having trouble figuring out what inv points to..either an
inventory record or an invoice record, I think.

Any thoughts?  Thanks for the response.

Cheers,
Jeff

-----Original Message-----
From: mschw at athenet.net <mschw at athenet.net> 
Sent: Tuesday, August 24, 2021 1:37 PM
To: 'Jeff Bandle' <jeffbandle at gmail.com>
Subject: RE: Newbie advice

Hi Jeff:

     Line 816 is trying to do something with a gfinvhis (filePro database
name) record that has not been looked up yet.   I'm guessing that gfinvhis
is probably an invoice history file.

     If you can send us line 816,  and perhaps a line or two before that, we
may be able to give you more help.  

     Line 816 should tell you the name of the aliased lookup. Line 816 might
say, "IF:  HISTORY(3)=2", and not have the word gfinvhis in it at all.   By
aliasing, I mean to look for a line that says something like "lookup
HISTORY=gfinvhis".  That's why we need you to find the lookup line that
looks up the gfinvhis file using the alias name in line 816.

Hope that helps!

Mike Schwartz

-----Original Message-----
From: Filepro-list
<filepro-list-bounces+mschw=athenet.net at lists.celestial.com> On Behalf Of
Jeff Bandle via Filepro-list
Sent: Sunday, August 22, 2021 8:11 PM
To: Filepro-list at lists.celestial.com
Subject: Re: Newbie advice

Hi All -

   A followup to my original 2+ month old post.  I first want to thank the
many folks who responded and reached out to me to help me start up the
FilePro learning curve.  I still have a way to go but I feel I am making
good progress and I've gotten to the point where I've been able to start
making a few simple fixes/enhancements to the FlowreSoft application.  I got
the Stuart L Werner Developer's Reference  from the STN folks and that has
been a great help in answering questions and providing insight as I start to
tackle more difficult problems.  

Given that, I do have a question.  In FlowerSoft, there is an operation
where you can reverse the charge on an invoice if that order gets cancelled
by the original customer.  However, that operation is failing with the
following abort..I'm linking a screenshot as a reference:

Any hints/recommendations on how to proceed debugging this?  I've looked at
the .prc code in the gfinvhis folder but I'm not seeing anything referencing
the index.P at line 816 anywhere.  What I've been able to figure out is
gfinvhis keeps track of the history of each invoice and I've seen a lot of
code make references to get a free value from the index when a new order is
being processed.  This makes sense to me as you would need a new entry for a
new invoice.  However, in this case, I think we are working on an existing
invoice.  

I want to figure this out but not sure how to proceed after what I think is
the obvious..maybe not.

Anyway, any ideas would be a great help.

Thanks and cheers,

Jeff

From: Jeff Bandle <jeffbandle at gmail.com>
Sent: Monday, June 7, 2021 7:59 PM
To: 'Filepro-list at lists.celestial.com' <Filepro-list at lists.celestial.com>
Subject: Newbie advice

Hi All -

   Long time lurker on this list but I'm compelled to ask for some advice.
A few weeks ago Nancy posted a notice that a long time FilePro programmer,
George Simon had unexpectedly passed away.  I knew George from working with
him the last 10 years, assisting him on the FlowerSoft Silver application
used by quite a few independent flower shops throughout the US.  I didn't do
any FilePro development but helped by providing standalone applications
George called to handle things such as decrypting wire orders and processing
credit card transactions.

  George's sudden passing has left these shops in an unsupported situation
and I've agreed to see if I can take this on in a very limited manner to at
least buy time for these shops to move onto another solution.  I've been
working with Nancy and the fptech folks and have gotten a 6.0 license for
the newest FilePro development environment.  In researching the installed
FlowerSoft software at several difference locations, it looks like George
included the source code with the executable bits.  

  What I'm asking is advice/guidance on the best way to proceed with ramping
up on FilePro so I can at least try to diagnose issues if they were
reported.  George and I had talked about me helping him and he was going to
provide guidance but sadly that never happened before his passing.  A
complicating factor is George was on FilePro 5.0 and I guess there are
potential conflicts if I use the 6.0 version that I will have to watch out
for.

  I apologize up front if this is too vague.  I've programmed in C, C++ and
C# along with MySQL and MS SQL, so I have a fair amount of programming
experience.  I've looked at the training materials available on the fptech
site but what I've seen seems to be geared for starting from scratch, not
how to support an existing project.

Thanks in advance for any tips.  I would like to have a setup where I make
changes on my local development machine and then role those changes to the
customer system, but maybe that isn't a good way to do it.  Any thoughts on
a recommendation for setting up a support "lab" would be very helpful.

Best regards,

Jeff Bandle

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://mailman.celestial.com/pipermail/filepro-list/attachments/20210822/96
314c92/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 68868 bytes
Desc: not available
URL:
<http://mailman.celestial.com/pipermail/filepro-list/attachments/20210822/96
314c92/attachment.jpg>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list