Newbie advice
Jose Lerebours
fpgroups at gmail.com
Tue Aug 24 12:51:32 PDT 2021
What is the error?
Your lookup commands says to push error upon fail ( -e )
Have you tried to rebuild free chain?
Have you tried to rebuild index files?
If file is locked, you may get an error since it cannot open a free
record and you are
implicitly asking for an error to be pushed.
I think fp introduced methods to check if error was due to record
locking or something of that
effect to provide a more efficient way to handle such situations.
Also, I personally never liked the use of -e, it does not exit
gracefully, it is like a "no mas" scenario
in a middle of a boxing match.
Hard to offer you a more direct suggestion without supporting info to
base it on.
On 8/24/21 3:23 PM, Jeff Bandle via Filepro-list wrote:
> 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
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
--
Jose Lerebours
(954) 559-7186
https://www.asisuites.com http://www.shipsuites.com
https://www.cargosaas.com https://www.helpsuites.com
ASI Suites Ship Suites CargoSaaS Help Suites
A robust, scalable & fully integrated application suitable for the most
demanding business environment! A load board designed to give you the
flexibility to manage traffic from/to your warehouse.
B2B UX/UI to allow your trucking partners pick the day and time they are
coming in thus preventing backlog in your yard.
TMS SaaS aimed to transform the way you do Transportation.
Designed with 3PL and Brokers in mind, this application has it all, from
RFQ to POD.
Need someone to handle your shipping? Give us a call, we offer very
competitive rates!
A friendly way to manage open & closed issues or requests for assistance.
WANTED! If you are looking for ready to roll out web based application,
give us a call and lets talk about great business opportunity with no
out of pocket investment.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210824/39681019/attachment.html>
More information about the Filepro-list
mailing list